Share via

SQL Server Merge Replication

Chad Smith 1 Reputation point
2022-06-21T19:20:42.933+00:00

The short of it is we had OS level system outages in a data center and lost some VM's one of which was a SQL Server that contained a publisher database to 4 subscriber databases that were on other VM's that were unaffected by the outage. I have rebuilt a SQL instance and restored a copy of my publisher database. I had to rebuild the replication on the publisher and setup a subscription for each site. Obviously I cannot let the initial snapshot overwrite or recreate any objects at the subscriber sites since they continued to operate during the outage so I cannot select the drop and recreate objects at the subscriber. The issue is this since it cannot do that the snapshot apply errors because it cannot apply the "rowguid" column and constraint at the subscribers (but they already exist) so I cannot get the snapshot to apply and setup a replication schedule. Any way to work around this since everything needed already exist at each subscriber database for replication to work. I just cannot get beyond initial snapshot application. Really appreciate any thoughts, I am in a bind and under pressure to get this up and running from management!

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.