Please enable JavaScript to view this site.

SQL Backup Master Help

Navigation: Backup job editor > Job settings

Database

Scroll Prev Top Next More

SQL Backup Master offers  a range of options affecting how it interacts with SQL Server during backup operations.

 

Database timeout - The number of seconds SQL Backup Master will wait when connectivity to SQL Server. This value is also used for normal database command operations, although some long-running commands (such as restore operations) will override it.

Add CHECKSUM option to database backup statement - If page checksums are turned on, you can use this option to validate them during backup.

Run RESTORE VERIFYONLY after backup - Runs a verification-only restore process after the backup completes (more information here).

Copy-only backup - Creates a backup that does not interfere with the existing SQL Server backup chain. A copy-only backup cannot serve as a differential base or differential backup and does not affect the differential base (more information here).

 

Advanced Options

 

SQL Backup Master provides advanced users the option of passing arguments (parameters) to the backup command that it constructs at run-time.

 

You should use this feature ONLY if you fully understand the implications of any arguments you specify and are prepared to test them thoroughly.

 

SQL Backup Master recognizes a specific subset of backup command line arguments (unrecognized arguments are ignored):

 

COPY_ONLY

COMPRESSION

NO_COMPRESSION

SKIP

NOSKIP

FORMAT

NOFORMAT

BLOCKSIZE

BUFFERCOUNT

MAXTRANSFERSIZE

CHECKSUM

NO_CHECKSUM

REWIND

NOREWIND

UNLOAD

NOUNLOAD

 

For details on the purpose of each of these arguments, see the documentation for your specific SQL Server version. Some arguments are available only in specific versions of SQL Server.

 

Multiple arguments should be separated by commas. For example:

 

COMPRESSION, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 4194304

 

Custom backup command arguments are applied to all backup types (full, differential, and log).