I am having a problem with replication between 2 databases. Here is some context on the setup.
I have 2 database servers, which are both running SQL Server 2005. Each database server contains a database called CRIS_TEST_ARCHIVE, these databases are setup as replication subscriber and publisher and replication has been running flawlessly so far.
As part of a project, we are archiving a lot of data, ie, removing it from the CRIS_TEST_ARCHIVE database and putting it into a different database. the export went fine, and I am partway through the step of deleting the redundant data from the current
database. This involves deleting a lot of rows from the source database and then running replication to ensure that the deleted rows also get deleted from the other replicated database.
I am running the deletes for each table one by one, and then running replication manually.
After one particularly large delete (about 9 million rows) i again started replication and got the following error in the replication manager:
The Merge Agent was unable to update information about the last synchronization at the Subscriber. Ensure that the subscription exists at the Subscriber, and restart the Merge Agent. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199481)
View Complete Post