Online Documentation for SQL Administrator for SQL Server

Setting backup options


This step offers some additional options that may be useful for the database backup operation.

 

Backup Database Wizard - Setting backup options

 

 

Set backup expiration date

You can set the expiration date by defining the number of days after that a backup will expire or by specifying an expiration date.

 

Backup verification options

 

!CheckBox Verify backup after creation

Check this option to enable backup verification.

 

!CheckBox Perform checksum verification before writing to media

This option enables/disables checksum verification before writing to the backup media.

 

!CheckBox Continue on checksum error

This option determines whether the backup operation will be stopped or forced to continue if an error occurs.

 

Backup compression

 

!RadioButton Server default

The backup compression is defined in compliance with the SQL Server property !CheckBox Compress backups by default.

 

!RadioButton On

Explicitly enable backup compression.

 

!RadioButton Off

Explicitly disable backup compression.

 

Note: Creating compressed backups is supported only in SQL Server 2008 Enterprise and later, but beginning in SQL Server 2008, every edition can restore a compressed backup.

 

Click the Next button to proceed to the Setting schedule options step of the wizard.