• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

SQL 2005 active/passive and database mirroring

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


Thanks
0
ITMaster1979
Asked:
ITMaster1979
2 Solutions
 
Scott PletcherSenior DBACommented:
Windows clusters share disk anyway, so clustering shouldn't affect database mirroring.
0
 
MrAliCommented:
Please review this article:
http://technet.microsoft.com/en-us/library/ms191309.aspx

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.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now