SQL Server Performance Forum – Threads Archive

Replication and Failover Mirroring

Is it possible to have fail-over using a mirror configuration also include transactional and merge replication? Heres my configuration; I have numerous remote sites which continuously gather data. The data is replicated to the central office using transactional replication. There is also merge replication in place where the publisher is at the central office and the subscribers are the remote sites. I want to put automatic failover db mirroring in place at the central office and would like this to include the transactional and merge replication that is in place as I just described. ie I want the failover to include the replication so that if/when a failover occurs, the replication will continue to occur to get the site data to the central office? Is this possible? Any thoughts would be appreciated.

While you can set up database mirroring for the database, this will not help you with replication, as database mirroing failover won’t failover your replication setup. A better solution, if you want additional fault tolerance, is to go with clustering, which will failover your replication setup. —————————–
Brad M. McGehee, SQL Server MVP

Replication and failover mirroring, sounds like having coffee with mix of salt [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. <hr noshade size="1">Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing.</center>

The replication is used to move data from db on remote sites to the CO. The mirroring was needed for fail over. Since mirroring is at the DB level and replication is at the Sql Server Instance Level, I need to use clustering. So now I am working with Virtual Server to configure and test clustering. [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] Thanks.

You can use "Replication with Database Mirroring", it is exactly what you are after. see
http://msdn2.microsoft.com/en-us/library/ms151799.aspx for details. Cheers

]]>