559
Chapter 21: Backup and Recovery Planning
21
The Options page presents the following options:■ Append to the Existing Backup Set or Overwrite All Existing Backup Sets:
Determines whether the current backup will be added to the backup fi le or whether
the backup media should be initialized and a new series of backups placed in them.■ (^) Check Media Set Name and Backup Set Expiration: Verifi es the name and expira-
tion date for the backup.
■ (^) Verify Backup When Finished: This verifi es that the backup is complete and the
fi le is readable. This option does not compare the data in the backup with the data
in the database, nor does it verify the integrity of the backup.
■ Perform Checksum Before Writing to Media: This verifi es that the data read from
the database is consistent with any checksum or torn-page detection on the data-
base. It also calculates a checksum of the entire backup and saves it in the backup.
This can help ensure that the database being backed up does not have any corrup-
tion due to the disk subsystem.
■ (^) Continue on Error: Enables backup to continue even after it encounters one or
more errors.
■ (^) Unload the Tape After Backup: Directs the tape to eject, which helps prevent
other backups from overwriting the backup fi le.
■ (^) Rewind the Tape Before Unloading: This is enabled only if you unload the tape
after backup is selected. This rewinds the tape before ejecting it.
■ (^) Truncate the Transaction Log: Backs up the transaction log and truncates
the inactive transactions to free log space. This is the default option for the
Transaction Log backup. This option is available only when the Transaction Log is
selected for Backup Type on the General page.
■ (^) Back up the Tail of the Log, and Leave the Database in the Restoring State:
Backs up the transaction log that has not yet been backed up. This option is
equivalent to using NO_TRUNCATE or NORECOVERY in the BACKUP statement. This
option is available only when the Transaction Log is selected for Backup Type on
the General page.
■ Set Backup Compression: Enables you to choose the default server-level backup
compression setting or ignore the server-level default and compress the backup
or do not compress the backup. At installation, the default behavior is no backup
compression. You can change this default by setting the default server-level backup
compression setting in Management Studio by checking the Compress Backup check
box in the Database Settings tab of Server Properties.
Backing Up the Database with Code
The BACKUP command offers a few more options than Management Studio, and using the
BACKUP command directly is useful for assembling SQL Server Agent jobs by hand, rather
than with the Maintenance Plan Back Up Database Task.
c21.indd 559c21.indd 559 7/31/2012 9:22:48 AM7/31/2012 9:22:48 AM
http://www.it-ebooks.info