User guide

where the contents of the batch file is

"net start MSSQLSERVER"

3.6.14.11 snapshot

--snapshot={always|possible|none}

Defines whether to back up files (p. 24) directly (one by one) or by taking an instant data snapshot.

Available values of the parameter are as follows:

 possible (by default)

Create a snapshot if it is possible. Back up files directly if taking a snapshot is not possible.

 none

Do not create a snapshot. Always back up files directly. Trying to back up files that are opened for

exclusive access will result in a read error. Also, files in the backup may not be time-consistent.

 always

Always create a snapshot. Using a snapshot enables the backing up of all local files. This includes

files opened for exclusive access. The files will be backed up at the same point in time. If a

snapshot cannot be taken, the backup will fail.

3.6.14.12 split

--split=<size>

If specified, the backup will be split into multiple files of the specified size (in MB). If not specified,

the software will split the backup when necessary. Such might be the case when the backup is placed

on removable media or on FAT16 and FAT32 file systems that have a file size limit of 2GB and 4GB,

respectively.

3.6.14.13 Tape management

tape_eject_successful

--tape_eject_successful

If the parameter is specified, the software will eject tapes after each successful backup. Otherwise,

tapes will not be ejected automatically.

tape_full_empty

--tape_full_empty

If the parameter is specified, each full backup will be written onto a free tape. Otherwise, the

software will try to write a backup onto a tape containing backups of the same backup chain or

archive. If not found, the software will try to use a free tape.

tape_overwrite

--tape_overwrite

The parameter applies only to stand-alone tape drives. If the parameter is specified, a tape inserted

into a drive will be overwritten every time a full backup is created.