How to sync SQL Server replication. Subscriber disconnected
We are using SQL Sever 2005 replication for the application. Everything works fine with no problem. Recently, however, we have encountered a situation for which I have no solution.
We use publisher merge replication (SQL Sever 2005) in one geography and subscribers (SQL Sever 2005 express) in several other geographic regions. Due to network problems at the subscriber's location, the subscriber cannot connect to the publisher and therefore cannot sync. Several tables in the subscriber have reached the allocated range, and now we cannot insert records into them.
Can this problem be solved? I could think of a few, but not sure how to proceed: me. Take a backup of the db subscriber, put it on another machine. Synchronize and restore back db. II. Copy all data from (modified / pasted) to Publisher (manually), reset sync between publisher and specified subscriber.
I'm not really sure if the above options are possible. Any help would be appreciated.
a source to share
No one has answered this question yet
Check out similar questions: