Home > IT Answers > SQL Server > Mirroring from a production environment to a ...
SQL Server Ask the Experts
2440 pts.
0
Q:
Mirroring from a production environment to a DR environment
SQL Server 2005 mirroring, Production environments, Disaster Recovery, SQL Server backup and restore, SQL Server Mirroring, SQL Server 2005
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?
ASKED: Jul 9 2009  3:03 PM GMT
0
Mrdenny
47070 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Jul 9 2009  9:26 PM GMT by Mrdenny   47070 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0