Post reply

test Disaster Recovery for snapshot

  • July 27, 2005 at 1:33 pm

    #102666

    I've just setup snapshot replication for mssql 2000.  I need to test it.  What is the best way to do a test that will make the Subscriber the primary server and the Publisher not publishing any longer for the duration of the Disaster Recovery test?

    One of the articles I read says to disable the publisher/subscriber on the publisher and subscriber.  When I did that, all the replication are gone including the distribution databases.  So when I need to revert back to the publisher to publish, I need to setup replication again.

     

    Is there another simple way to do it ?

     

     

     

  • July 27, 2005 at 1:57 pm

    #577710

    not that I know of, you need repoint the apps to the subscriber, then rebuild the repl and repoint back to the publisher

  • July 28, 2005 at 4:37 am

    #577810

    have a look at bi-directional tranasactional replication.

     

    --

    Hilary Cotter

    Looking for a SQL Server replication book?

    http://www.nwsu.com/0974973602.html

    Looking for a FAQ on Indexing Services/SQL FTS

    http://www.indexserverfaq.com

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

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