Greetings! I need your advice for two questions. This is related to design.
I have a production site. It requires HA. At the same time we have a DR site. The DR site needs to have the same copy of the database for my application to run.
Question 1: Is it advisable to have mirroring on the production site? For this, we have the HA on the cluster. At the same time, we will implement cluster failover to another instance of SQL Server at the DR cluster.
Question 2: Is there any technical operational document on archiving the database from local storage to a SAN?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!