Making a full backup

A full backup is a backup of the database file and the transaction log file.

For more information about the difference between a full backup and an incremental backup, see Types of backup.

To make a full backup (overview)

Ensure that you have DBA authority on the database.
Perform a validity check on your database to ensure that it is not corrupt. You can use the Validation utility or the sa_validate stored procedure. See Validating a database.
Make a backup of your database file and transaction log.

For information about how to perform the backup operation, see:

Notes

Validity checking requires exclusive access to entire tables on your database.

For more information and alternative approaches, see Ensuring your database is valid.

If you validate your backup copy of the database, make sure that you do so in read-only mode. Start the database server with the -r option to use read-only mode.

Send feedback about this page via email or DocCommentXchange