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.
Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s