Understanding disaster recovery options for SQL Server

One of the challenges IT and database administrators confront when implementing disaster recovery provisions is choosing from among the myriad options available. Existing high availability configurations designed to minimize downtime for critical applications may not be adequate for recovering fully from a widespread disaster. And existing disaster recovery provisions may not be as comprehensive or cost-effective as they could be. This article provides practical guidance to help administrators optimize disaster recovery plans for SQL Server, beginning with the disaster recovery plan. A good disaster recovery plan builds on the organization’s Business Continuity Plan. BCPs generally cover the entire organization, and… [Continue Reading]