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?