Home Forums SQL Server 2008 SQL Server 2008 - General Huge Transaction on Database with Merge Replication, Simple Recovery Model RE: Huge Transaction on Database with Merge Replication, Simple Recovery Model

  • Is Replication working at all? If records cannot come over to the Subscription database, they will pile up in the Log file.

    Have you dropped and recreated the Publication after fixing the Page?

    In your case, I would first run the Replication Creation scripts. If that does not fix the issue, I would drop and recreate the whole Publication and Subscription. Make sure to run sp_removedbreplication on the replicated database after you run the Drop scripts.