locked
Mirroring and replication in same database RRS feed

  • Question

  • Hi,

       In my environment we have a 350Gb of database for which we have configured DB Asynchronous mirroring for DC to DR. We have also configured Transactional replication with 2 subscriber and Snapshot replication with 1 subscriber for that same database. If in case DR happens what steps i have to follow for replication from DR?. We have seperate server in DR also for the subscriber. But our network bandwidth is 4 mbps only.

     

    Friday, December 26, 2014 4:53 AM

Answers

  • How frequently you are backing data on the DR subscribers?. For transactional replication, Keep the scripts ready and synchronize the subscription with backup("Replication support only" feature.

    Please refer the basic details for better understanding.

    http://msdn.microsoft.com/en-us/library/ms151799.aspx

    For rest, you need to rebuild it from the scratch. Good backup and restore strategy will help you a lot in this case.

    http://www.sqlservercentral.com/scripts/Replication/70508/

    --Prashanth



    Friday, December 26, 2014 3:02 PM