Post reply

How to make restore of db which is subscriber and publisher in SQL Server 2000

  • August 27, 2009 at 2:01 pm

    #135698

    Hi,

    I have on MS Sql 2000 database which is used in replication - it is publisher and subscriber.

    Unfortunately this database corrupted and I need to make restore on it.

    How should I proceed to make it properly so after restore the replication will be work as usual?

    I will appreciate you help very much!

  • August 27, 2009 at 2:07 pm

    #1045855

    I am not sure if the replication would work after restoring the two databases. What I would suggest is to remove the replication. Restore the databases and set up the replication again.

  • August 27, 2009 at 2:32 pm

    #1045875

    Hi

    Thank you for reply. I want to rectify that I am talking about one database.

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

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