Home > IT Answers > Storage > Mirroring from a production environment to a DR environment
SQL Server Ask the Experts
2,585 pts.
 Mirroring from a production environment to a DR environment
Disaster Recovery, Production environments, SQL Server 2005, SQL Server 2005 mirroring, SQL Server backup and restore, SQL Server Mirroring
I have a production environment and a disaster recovery environment and each of them have two SQL 2005 servers in a cluster. We have two LANs -- the first one is our standard/everything LAN and the second is a Service LAN. We are looking to mirror from our production environment to our DR environment. Is this possible? Can I just put the SQL Cluster Heartbeat on the Service LAN, or do I need a third NIC? Is it just a configuration setting in SQL Server?

Software/Hardware used:
ASKED: July 9, 2009  3:03 PM
UPDATED: July 9, 2009  9:26 PM
RELATED QUESTIONS
Answer Wiki:
You can create a single cluster that spans the two sites. This requires that both SANs are able to talk to each other and do async replication between them. The more common technique is to use database mirroring between the two sites.
Last Wiki Answer Submitted:  July 9, 2009  9:26 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _