Hi All,
We are using SQL Sever 2005 replication for out application. Every thing is working fine without any problems. However, recently we ran into a situation to which I have no solution.
We use merge replication with the publisher(sql server 2005) in one geography and the subscribers(sql server 2005 express) in multiple other geographies. Because of network issues at the subscriber location, the subscriber is not able to connect to the publisher and hence not able to synchronize. A few tables in the subscriber have reached the alloted range and we are now unable to insert entries into them.
Is there any way I can resolve this issue? I could think of a few but not sure how to proceed with them: i. Take a backup of the subscriber db, put it on a different machine. Synchronize and restore back the db. ii. Copy all the data from (modified/inserted) into the Publisher (manually), reset the synchronization between the publisher and the said subscriber.
I am not very sure the above choices are feasible. Any help will be appreciated.
Thanks, Ramjee