Delete command from Distribution Database

  1. Identify the publisher database id
    SELECT * FROM MSpublisher_databases
  2. Identify the ID number and command id of the command causing the problem. This will typically show up in the Replication Monitor.
  3. Execte the sp_browsereplcmds stored procedure to identify the command with the problem.
    EXECUTE distribution.dbo.sp_browsereplcmds
        @xact_seqno_start = '0x0001DAB7000027C8000100000000',
        @xact_seqno_end = '0x0001DAB7000027C8000100000000',
        @publisher_database_id = 7,
        @command_id = 1
  4. Delete the command from MSRepl_commands using the xact_seqno and command_id
    DELETE FROM MSrepl_commands WHERE xact_seqno = 0x0001DAB7000027C8000100000000 AND command_id = 1
  5. Rinse and repeat as necessary.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s