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 |
|
Jaybee from his castle
Yak Posting Veteran
64 Posts |
 Posted - 2006-05-04 : 06:38:49
|
| Hi all, firstly excuse my ignorance if these are basic issues, been a long time since I studied Replication.I'm on a greenfield site and inherited 2 databases of the same name, structure, and similar sizes, but on different servers, on this site and on a remote one.My question now is how do I determine IF the remote server is successfully replicating, and how often, given that the copy on subscribing server (local) is only 7.5Gb? Any help appreciated,Jaybee. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-04 : 10:12:26
|
i haven't tried this, you can retrieve the status from the following tables according to BOL...msrepl_% tablesMSreplication_% tablesbut what i did was low tech, i took the jobhistory for the agents  --------------------keeping it simple... |
 |
|
|
|
|
|
Determining success/frequency of Replication