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?