Backup and Restore Options

Backup options enable you to do the following:

Perform a Full or Differential backup of a database
Back up the entire database, a selected set of files and FileGroups within a database, or an automatically-selected set of FileGroups that contain changeable data
Back up the transaction log of a database, with or without truncating the log
Take the database offline automatically after a transaction log backup, leaving it in a restoring state
Check the consistency of databases before and after backup
Perform both a Data and Transaction Log backup of a database in a single backup job
Include SQL Server’s native error checking information as part of the backed-up data

For more information about backup options, see the section, Backing Up Microsoft SQL Server Databases.

Restore options enable you to do the following:

Restore data and transaction logs
Automatically determine a sequence of backups to restore, to produce a live, consistent database with a single restore job
Use transaction log restores to restore the data to a specific point in time, or to the start or end of a named transaction
Restore the entire database or a selected subset of the database files and FileGroups
Restore a selected subset of the database as a new database
Perform a Torn Page Repair of a database, even while it is online
Leave the database in a restricted access mode
Preserve or clear the replication settings of the restored database
Change the physical location on disk of data and transaction log files
Check only the physical consistency of a database after restore is complete
Override any inconsistencies found with SQL Server’s native error checking information

For more information about restore options, see the section, Restoring Microsoft SQL Server Databases.