DR/HA questions with SQL Server design

Tags:
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!

ASKED: March 30, 2010  10:16 PM
UPDATED: March 31, 2010  3:48 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SQL Server Ask the Experts
    [...] DR/HA questions with SQL Server design, asked by SQL Server Ask the Experts and answered by [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following