Home > IT Answers > SQL Server > DR/HA questions with SQL Server design
SQL Server Ask the Experts
2,585 pts.
 DR/HA questions with SQL Server design
SQL Server, SQL Server availability, SQL Server backup and restore
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?

Thanks very much!



Software/Hardware used:
ASKED: March 30, 2010  10:16 PM
UPDATED: March 31, 2010  3:48 AM
RELATED QUESTIONS
Answer Wiki:
Typically people use Windows/SQL Clustering for HA at the local site, then use database mirroring from the primary site to the backup site. Please define Archiving. If you are simply moving data from a database on local storage to a database on SAN storage, then no there's no documents as the SQL Server just sees a disk.
Last Wiki Answer Submitted:  March 31, 2010  3:48 am  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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