Designing a Backup and Restore Strategy

Administering SQL Server

Administering SQL Server

Designing a Backup and Restore Strategy

You must identify the requirements for the availability of your data in order to choose the appropriate backup and restore strategy. Your overall backup strategy defines the type and frequency of backups and the nature and speed of the hardware required for them.

It is strongly recommended that you test your backup and recovery procedures thoroughly. Testing helps to ensure that you have the required backups to recover from various failures, and that your procedures can be executed smoothly and quickly when a real failure occurs.

This section includes the following topics.

Topic Description
Analyzing Availability and Recovery Requirements Explains the basic requirements for developing a backup and restore plan.
Planning for Disaster Recovery Explains how to plan for a disaster (for example, the complete loss of a server).
Selecting a Recovery Model Introduces Microsoft® SQL Server™ 2000 recovery models, which you implement after analyzing your availability requirements.