Disaster Recovery Planning for SQL Server

Ideally, hard drives and servers would never malfunction, software would never be at risk of corruption and there would be no harm caused by human error. However, since one or more of these possible data threats are inevitable, there should be a solid disaster recovery plan in place in preparation of adverse events. A disaster recovery plan (DRP) is the set of actions that database administrators (DBAs) take to handle adverse events that may affect the availability of their database environments. Disaster recovery planning is the work 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. Some examples of disasters include a natural or 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. DBAs should always plan backups and restores as the first line of defense of the disaster recovery plan.

Download White Paper