Debugging Replication Errors

use distribution
--------------------------------------------------------------------------------
select top 100 e.*, * from MSrepl_commands c inner join MSrepl_errors e on c.xact_seqno =e.xact_seqno order by e.id desc
--------------------------------------------------------------------------------
exec sp_replmonitorhelpsubscription @publisher=NULL, @publication_type=0
--------------------------------------------------------------------------------
exec sp_helpdistpublisher
--------------------------------------------------------------------------------
exec distribution..sp_replmonitorsubscriptionpendingcmds @publisher=pubservername, @subscriber=subservername, @publisher_db='pubdbname', @subscriber_db='subdbname', @publication='pubname', @subscription_type=0
--------------------------------------------------------------------------------
exec sp_replqueuemonitor @publisher = pubservername, @publisherdb = 'pubdbname', @publication = 'pubname', @tranid = NULL, @queuetype = 0
--------------------------------------------------------------------------------
exec sp_replshowcmds

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 )

Facebook photo

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

Connecting to %s

A WordPress.com Website.

Up ↑

%d bloggers like this: