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
LVL 1
ITMaster1979Asked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior DBACommented:
Windows clusters share disk anyway, so clustering shouldn't affect database mirroring.
0
 
MrAliConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.