Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MSreplication_objects seems to be out of sync Expand / Collapse
Author
Message
Posted Thursday, October 18, 2012 3:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 2:05 AM
Points: 161, Visits: 455
I am into a new job and today I got some requests related to a database involved in replication. The database is a subscriber involved in transactional replication with push subscriptions. I had to check the tables involved in replication in the subscription database, so I used the MSreplication_objects table to get the list of articles. But when I cross verified the list against the publisher database, some of the articles were missing in the publisher. And also there was a record count difference for some of the tables across the publisher and subscriber, meaning those tables were not replicated. Is there any chance MSreplication_objects table would be out-of-sync and can show obsolete articles?

Also please suggest if there is any other way to check in the subscription database if a table is a replicated copy or not.
Post #1374212
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse