Post reply

Table deleted in Replicated Database

  • February 4, 2011 at 8:13 pm

    #233961

    We had a table get deleted in the replicated database. We are running transactional replication with a snapshot run every night. I thought it would not be a problem that it would be put back with the snapshot, but it didn't. I have tried reinitializating the replication with a new snapshot, but that didn't help either. How do we get this table back?

  • February 4, 2011 at 8:26 pm

    #1282769

    Script out the table on the publisher and then recreate it on the subscriber. Once you have done that the reinitialization with the snapshot will synch the table back up and it will continue to replicate after that.

    Regards,

    Jason P. Burnett
    Senior DBA

  • February 4, 2011 at 10:35 pm

    #1282777

    I'll try that. Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

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