Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x000210C100000223000D00000000, Command ID: 8)
Ex:
Step 1 :-
Connect to the Distributor
select * from dbo.MSarticles
where article_id IN (SELECT Article_id from MSrepl_commands
where xact_seqno =
0x000210C100000223000D00000000 )
Step 2 :-
Step 2 :-
exec sp_browsereplcmds @xact_seqno_start = '0x0013DD67000002EA007F00000000'
,@xact_seqno_end = '0x0013DD67000002EA007F00000000'
,@publisher_database_id = xxx
,@article_id = xxx
,@command_id= '8'
,@xact_seqno_end = '0x0013DD67000002EA007F00000000'
,@publisher_database_id = xxx
,@article_id = xxx
,@command_id= '8'
Step 3:-
If data is in sync, do skip errors
If data is in sync, do skip errors
For replication Errors,
select
*
From distributor..MSrepl_errors
Select * from MSrepl_commands Where xact_seqno>'0x0000000000000000000000000000'
Which will give the article details and issues.
No comments:
Post a Comment