Transaction replication info

Hi,
 
To continue with the replication discussion, on my last post i discussed on some important commands and sp’s for how to configure the replication and its steps.. (I will be discussing only about Transactional Replication). and also about how log reader works.
 
Before going for troubleshooting and issues we should know the following about transaction replication:
1.Just want to be clear that when you do any UPDATE command(s) on publisher it will be DELETE and INSERT at subscriber. until
DBCC TRACEON (8207, -1)
2. all the commands which will replicate will be on
sp_browsereplcmds — you can see the commands (sql query) which is pending to go to subscriber (very imp)
 
3. distribution.dbo.sp_browsereplcmds  refers – distribution.dbo.msrepl_commands and distribution.dbo.ms_repltransaction  with key “xact_seqno” .
 
4. distribution.dbo.MSrepl_errors is another important table which shows the error message (reason for replication failure) very important for troubleshooting replication issues.
 
5. publisher.dbo.sysarticles at publisher this commands shows what all articles publisher is enable for replication.
 
6. their are commands(Stored Procedures) which runs when you do any transactions(insert, update or delete).
Bi-directional transaction replication:
 
HTH.
Vinay
 
 
Advertisements
This entry was posted in Replication and tagged . Bookmark the permalink.

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