So, I am researching the ins-and-outs of programmatically monitoring SQL Server 2008 Replication. Until today, I thought that the only replication status information to glean from SQL Server was whether replication is actively going on or not. Based on some information provided by Robert Levy, it seems that Replication Management Objects (RMO) may offer fine-grained feedback on replication status. The link he provided points me to a MSDN page titled Using the Subscriber Monitor Sample.
To effectively understand the solution on that page, I need to download some sample databases. The main purpose of this post is, in fact, to help me remember that the SQL Server samples are all housed at CodePlex as http://sqlserversamples.codeplex.com. I am focused on SQL Server 2008 (original, not R2).
Of particular interest:
1) AdventureWorks2008_SR4
2) The Sales Orders Sample for Merge Replication. (Installation Instructions)
I hope to post my findings soon.
Chris
No comments:
Post a Comment