Backup and recovery tasks

This section collects together instructions for tasks related to backup and recovery.


Implementing a backup and recovery plan
Making a full backup
Making an incremental backup
Validating a database
Validating a single table
Validating a transaction log
Making a backup, continuing to use the original transaction log
Making a backup, deleting the original transaction log
Making a backup, renaming the original transaction log
Determining which connection has an outstanding transaction
Renaming the backup copy of the transaction log during backup
Backing up a database directly to tape
Making a live backup
Recovering from media failure on the database file
Recovering from media failure on an unmirrored transaction log
Recovering from media failure on a mirrored transaction log
Recovering from a live backup
Restoring an archive backup
Recovering uncommitted operations
Recovering from multiple transaction logs
Changing the location of a transaction log
Creating a database with a transaction log mirror
Starting a transaction log mirror for an existing database