Home Forums SQL Server 2005 SS2K5 Replication Dealing with a database corruption on a merge replication subscriber RE: Dealing with a database corruption on a merge replication subscriber

  • If you can't do a page level restore, that leaves you with 2 options. You can restore the whole database and renitialize replication to it. Or you try running DBCC CheckDB with repair and then manually syncing the data that is missing.

    Running repair will delete the bad page and fix up any links to it. So you will need to re-insert any records on that page.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]