Backing Up and Restoring Databases
The backup and restore component of Microsoft® SQL Server™ 2000 provides an important safeguard for protecting critical data stored in SQL Server databases.
With proper planning, you can recover from many failures, including:
- Media failure.
- User errors.
- Permanent loss of a server.
Additionally, backing up and restoring databases is useful for other purposes, such as copying a database from one server to another. By backing up a database from one computer and restoring the database to another, a copy of a database can be made quickly and easily.
This section provides the information necessary to implement a complete backup and recovery plan.
|Designing a Backup and Restore Strategy||Helps you analyze and refine your data availability requirements and choose a recovery model for each database.|
|Using Recovery Models||Describes each recovery model in detail, as well as appropriate backup and restore strategies. This topic also describes how to switch between recovery models.|
|Backup and Restore Operations||Describes the various types of backups available and how they are used. This topic also describes point-in-time recovery, restarting a failed backup or restore, recovering to a particular transaction, and recovering part of a database.|
|Managing Backups||Describes backup devices, the backup format, and removable media terminology. This section also describes password security and media management including formatting, appending, overwriting, listing, and verifying media contents.|
|Backing Up and Restoring the System Databases||Describes the procedures necessary to protect and recover the system databases.|
|Handling Large Mission-Critical Environments||Describes features and techniques appropriate for highly available or very large production databases. These include using multiple backup devices, file and filegroup backups, file differential backups, and snapshot backups.|
|Copying Databases to Other Servers||Describes the use of backup and restore to quickly transport a database to another server.|