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

Accidental Merge Replication Reinitialize Expand / Collapse
Author
Message
Posted Tuesday, April 26, 2011 2:42 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 7:32 AM
Points: 1,327, Visits: 4,504
A client accidentally marked all subscriptions for reinitialization in one merge replication publication. Everything is back up and running (after a lengthy outage), and I'm now tasked with seeing if it's possible to "undo" this should it happen again.

I started working my way through the metadata changes that are made when this is done, and it's looking to be either a major task or completely impossible.

Does anybody have any scripts or articles or advice that may help me?



Post #1098448
Posted Wednesday, May 16, 2012 1:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 22, 2013 7:52 PM
Points: 2, Visits: 48
Hi, can you please tell me how to search for text "SYNC" from MSrepl_commands or sp_browsereplcmds? Thank you
Post #1301315
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse