Error with dropping Transactional Publication


  • Running SQL 2012.

    Currently merge and transactional replication are setup on the datbase (db1). Trying to drop the publication is generating a log reader agent error.

    Exec sp_droppublication @publication = 'transactional_pub', @ingnore_distributor = 1

    "Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you executed a log-related procedure, drop the connection over which the procedure was executed or execute sp_replflush over that connection before starting the Log Reader Agent or executing another log-related procedure. "

    Error From Event viewer:

    Replication-Replication Transaction-Log Reader Subsystem: agent 'srv-transactionalpub' failed. The process could not execute 'sp_replcmds' on Server

    I am not running any other log reader agent or log related storedproc in any connection.

    The following didn't work:
    Restarted the log reader agent.
    Removed replication objects from subscription using sp_removedbreplication - To remove any orphaned metadata from subscriber.

    Any ideas on how to fix this?

    • Moved by Tom Phillips Tuesday, November 13, 2012 7:11 PM Replication question (From:SQL Server Database Engine)
    Monday, November 12, 2012 2:58 PM

All replies