The Snapshot Agent corresponding to the publication ‘%s’ could not be dropped.

Details
Product: SQL Server
Event ID: 20010
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: The Snapshot Agent corresponding to the publication ‘%s’ could not be dropped.
   
Explanation
This error occurs when dropping a merge replication publication. sp_dropmergepublication cannot drop the Snapshot Agent for the specified publication. The specified publication name may not exist in the publishing database. Perhaps a prior attempt to remove replication from the database did not completely remove all remnants of merge replication.
   
User Action
If other errors occur at the same time as this error, troubleshoot them first.

Run SQL Profiler against the relevant SQL Server instance to capture “Errors and Warnings” events. Sometimes this will capture errors that are otherwise not seen.

You may need to manually remove the replication. For more information about how to manually remove replication, see Microsoft Knowledge Base article 324401.

Related:

Leave a Reply