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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2009-06-15 : 11:35:45
|
| Hi All,i've production database, Mydb. i've configured transactional replication, and generated snapshot and working fine without any issues. but what is the actual way to know wether everything is working fine? all the data has been replicated or not? likethis?please let me know in this regardArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-15 : 11:52:52
|
| insert/update/delete some data on the publisher and verify if the same operation has been replicated on the subscriber.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2009-06-15 : 12:35:55
|
| are there any dbcc commands or extended stored procedures?i told the answer like that (i can check with the date time columns at publisher and subscriber) in the interview. he is expecting some dbcc or extended stored procedures. can you help me in this regard...ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-15 : 14:49:00
|
| There are no DBCC commands... you can check in Replication monitor which will tell you if replication is working fine or not.. however I always run a TSQL (even if its a simple update on a table... ) and manually verify..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
how can i say my replication is done well