none
SQL Server Replication and Mirroring RRS feed

  • Question

  • Hi, advices needed. I have a database on server A that is async mirrored over to server B, while at the same time, it is replicated to server C. What I noticed is that when the mirroring is down, due to whatever reason, the replication can not be completed either. Only when mirroring is later caught up, then the replication resumes. Anyway around this? The goal is to keep replication going, even though mirroring might be down temporarily.
    Thanks in advance.
    Thursday, February 4, 2010 4:18 AM

Answers


  • If you have  Replication conjugated with  Database Mirroring then Publisher will be redirected whenever the database mirroring failover happens.

    So  , your principal and mirror should share a Distributor here where subscribers will connect to regardless of the state of the database mirroting.

    You can kindly read here about requirements and configuration

     

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

     

    A good whitepaper is here

    http://sqlcat.com/whitepapers/archive/2008/09/02/sql-server-replication-providing-high-availability-using-database-mirroring.aspx

     

    and a blog

    http://sqlserver-qa.net/blogs/replication/archive/2008/12/15/5165.aspx

    HTH


    Please mark as answer if you think this answers your questions
    Thursday, February 4, 2010 7:44 AM
  • There is no way to do this.

    Both replication and database mirroring use the transaction log. If mirroring is down the log reader agent will be unable to read the log.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Thursday, February 4, 2010 1:36 PM
    Moderator

All replies


  • If you have  Replication conjugated with  Database Mirroring then Publisher will be redirected whenever the database mirroring failover happens.

    So  , your principal and mirror should share a Distributor here where subscribers will connect to regardless of the state of the database mirroting.

    You can kindly read here about requirements and configuration

     

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

     

    A good whitepaper is here

    http://sqlcat.com/whitepapers/archive/2008/09/02/sql-server-replication-providing-high-availability-using-database-mirroring.aspx

     

    and a blog

    http://sqlserver-qa.net/blogs/replication/archive/2008/12/15/5165.aspx

    HTH


    Please mark as answer if you think this answers your questions
    Thursday, February 4, 2010 7:44 AM
  • There is no way to do this.

    Both replication and database mirroring use the transaction log. If mirroring is down the log reader agent will be unable to read the log.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Thursday, February 4, 2010 1:36 PM
    Moderator