Post reply

how to fix corrupted table in merge subscription

  • March 10, 2007 at 4:51 am

    #98181

    I have Server A ( Publisher) Type : Merge

    and Server B (Subscriber ) PULL.

    On Server B ( Subscriber) replicated data currupted for 2 millions rows.

    could you please help me anyone.

    Thanks

    Regards

    Nikie

     

     

  • March 11, 2007 at 12:04 am

    #694264

    Run the DBCC CHECKTABLE to check the corruption...

    Some times rebuilding index will remove the corruption if the indexes are corrupted.

    If reindexing not fixed the problem...

    Run DBCC CHECKTABLE with repair allow data loss ....check BOL for syntax...

    Final option will be disable subscription to correpted table and delete the table and re-enable subscription...

     

     

    MohammedU
    Microsoft SQL Server MVP

  • March 12, 2007 at 5:26 am

    #694323

    Thanks very much,

    could you please email about how to disable subscription .

     

    thanks

    nikie

  • March 12, 2007 at 7:07 am

    #694342

    Hi Nikie,

     

    I think it would be unwise to do a "repair allow data loss" on a subscribed table. 

    In my opinion you should figure out if the problem is in an index, which can be easily fixed by dropping and recreating the index.

    If it's not, you are probably going to want to reinitialize your subscription, unless you already know how get replicated tables back in sync manually.

    jg

  • March 15, 2007 at 3:50 am

    #695163

    Thanks very much,

     

    Best Regards

    Ponnu

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply