I have a client set up using SQL Server 2005 SP3 Standard edition on two servers (both Wondows 2003 Server Enterprise edition).
I Have a Merge replication running between the two servers with the ditributor being the controlling server (push replication).
This replication has been running for several months until yesterday at around 2pm. The replication stopped and I am receining the following errors from withing the replication monitor in the Management Studio...
The merge process could not retrieve the list of subscriptions. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201009)
Get help: http://help/MSSQL_REPL-2147201009
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
Can anyone help with this> I know I can create a new snapshot and pass back over the the subscriber to fix BUT I will lose the changes made since 2pm yesterday. Can anyone assist me with how I reesatblish the current replication with the existing
subscriber. Or at least recover all data into one set so we can start again?
I look forward to your replies and thank you for your time,
View Complete Post