SQL 2005 active/passive and database mirroring

Posted on 2012-09-07
Last Modified: 2012-10-15
Hi All,

  I have two sites ( Site A , Site B ), in Site A i have two SQL servers configured as active/passive running windows 2003 64 bits and SQL 2005,  Im planning for a disaster recovery in site B, I have installed windows 2003 , SQL 2005 in site B, I need to replicate the Data using Database mirroring, can someone advise me how to combine sql active/passive with Database mirroring.

I need detailed steps if possible

Question by:ITMaster1979
    LVL 68

    Accepted Solution

    Windows clusters share disk anyway, so clustering shouldn't affect database mirroring.
    LVL 7

    Assisted Solution

    Please review this article:

    Mirroring and clustering can work together but there's caveats that could cause a mirroring failover to occur during a cluster node failover, in certain scenarios.  

    A mirroring failover will cause application downtime if your connection strings don't automatically go to the new IP through a 'failover' entry in the config.  

    This isn't a issue when you are only using clustering and no mirroring, as when you failover in clustering since the connection string never changes, you hit a virtual clustered IP that never changes.  With mirroring, you go to a different machines IP.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    By default, Carbonite Server Backup manages your encryption key for you using Advanced Encryption Standard (AES) 128-bit encryption. If you choose to manage your private encryption key, your backups will be encrypted using AES 256-bit encryption.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
    This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now