Post reply

Transactional Replication fallback

  • April 13, 2005 at 8:07 am

    #88682

    I have transactional replication setup between PrimarySvr and StandbySvr. Would appreciate your responses on:

    - If PrimarySvr goes down, can I just point users to StandbySvr.

    - When PrimarySvr comes up (say after 24 hours) how do I synch PrimarySvr and restart replication from PrimarySvr to StandbySvr?

    Thanks

  • April 14, 2005 at 4:58 am

    #552650

    the best way to do this is either by using bi-directional transactional replication or merge replication. To start for bi-directional transactional replication you will need to restore the publication database on the subscriber. Make sure you make all triggers, constraints, identity columns not for 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

  • April 14, 2005 at 8:38 am

    #552723

    I'll go for merge in this case!


    * Noel

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

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