Welcome to

SqlServer-QA.net

Sign in | Join | Help

Business Continuity (SSQA.net)

Business continuity & Contingency planning - essential and unavoidable tasks.
Disaster recovery options for SQL Server

Have you ever wondered what could be the Disaster Recovery (DR) options available for SQL Server.

In the documentation terms: Disaster recovery is a process that you can use to help recover information systems and data, if a disaster occurs. Some examples of disasters include a natural or a man-made disaster such as a fire, or a technical disaster such as a two-disk failure in a Redundant Array of Independent Disks (RAID) 5 array.

Disaster recovery planning is the work that is devoted to preparing all the actions that must occur in response to a disaster. The planning includes the selection of a strategy to help recover valuable data. The selection of the appropriate disaster recovery strategy depends on your business requirements.

On the large scale explanation Microsoft has mentioned about these options in this KBA link.

Posted: Friday, May 25, 2007 4:13 PM by SQL Master

Comments

No Comments

Anonymous comments are disabled