EMS logo

Products Navigation

SQL Backup for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Backup for SQL Server

On-line Documentation

Verify options


At this page you can define backup verifying options.

 

Editing Service task template - Backup Database - Verify Options

 

 

CheckBox Verify backup when finished (VERIFYONLY)

Check this option to enable backup verification. Verifying a backup checks that the backup is intact physically, to ensure that all the files in the backup are readable and can be restored, and that you can restore your backup in the event you need to use it.

 

CheckBox Perform checksum before writing to media (CHECKSUM)

This option enables/disables checksum verification before writing to the backup media. Before writing a page to the backup media, BACKUP verifies the page, if this information is presented on the page. BACKUP generates a separate backup checksum for the backup streams. Restore operations can optionally use the backup checksum to validate that the backup is not corrupted. The backup checksum can optionally be used at restore time. Using backup checksums may affect workload and backup throughput.

 

CheckBox Continue on error

This option determines whether the backup operation will be stopped or forced to continue despite encountering errors such as invalid checksums or torn pages.

 

CheckBox Detect possible backup sequence breaks

If the option is switched on the program analyzes SQL Server backup history to check if additional backups were made by third-party software between the backups required to restore the current backup. The program generates warning if such backups are found. Use this option to reveal the cases when backups are performed explicitly using VSS interface, by maintenance plans working on server or by another third-party software at same time with EMS SQL Backup. The restoring procedure may require backup files created by different software in those cases. This option is only supported in the EMS SQL Backup provider selected.