Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2009-03-19 : 09:11:47
|
| Hi AllWe are using transactional replication to populate the data from one database to other database.Publisher,Distributor and Subscriber are on the same server.How can I make sure the transactional replication is working fine and in healthy state.Thanks. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-03-19 : 10:11:02
|
| Launch the replication monitor and see what it says for your publication, this can be found if you right click on Replication in Management Studio. You can even send tokens to see what latency you have. |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-03-19 : 11:20:52
|
| You can also use this proc if you dont want to use the GUI: sp_replmonitorsubscriptionpendingcmdsDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
how to check the replication is working or not