November 4, 2016 at 11:54 pm
Publisher to Distributor History and in Distributor to Subscriber History I can see -
1 transaction(s) with 1 command(s) were delivered.
How to validate what was the change been applied to subscriber from publisher?
Thanks.
November 7, 2016 at 12:23 pm
I'm not aware of a way to see the actual transactions that were published. We usually just roughly validate replication using table row counts on PROD vs. the replicated DB.
November 8, 2016 at 6:00 am
SQL-DBA-01 (11/4/2016)
Publisher to Distributor History and in Distributor to Subscriber History I can see -1 transaction(s) with 1 command(s) were delivered.
How to validate what was the change been applied to subscriber from publisher?
Bit hard to get exact that one command if data is continuously flowing. But if replication is not very busy you could get xact_seqno from msrepl_transactions (order by entry_time) on distributor
or get xact_Seqno from msdistribution_history (for specific distribution agent id and time)
and try browse the command using following proc (on distribution db):
exec sp_browsereplcmds
@xact_seqno_start=<seqno>,
@xact_seqno_end=<seqno>,
@publisher_database_id=<publisher_db_id>,
if you want to browse one transaction (one seqno) than just put same xact_seqno under start and end. This proc will show u all commands/replication procs for given transaction (be careful if there are large transactions - that contains thousands of commands).
U can narrow down the results if u need to by providing more parameters:
sp_browsereplcmds [ [ @xact_seqno_start = ] 'xact_seqno_start' ]
[ , [ @xact_seqno_end = ] 'xact_seqno_end' ]
[ , [ @originator_id = ] 'originator_id' ]
[ , [ @publisher_database_id = ] 'publisher_database_id' ]
[ , [ @article_id = ] 'article_id' ]
[ , [ @command_id= ] command_id ]
[ , [ @agent_id = ] agent_id ]
BartL
Replication Blog
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply