X hits on this document

723 views

0 shares

0 downloads

0 comments

107 / 200

Using NetBackup for SQL Server Using batch files

107

Keywords and values used in batch files

Table 5-12

This following keywords and values can be used in batch files. Keywords and values used in batch files

Keyword

Values

Required?

Default

Description

ALTCLIENT (Same as BROWSECLIENT)

string

no

none

Restores images from a host other than the local host.

BACKUPMODEL

BACKUPMODEL_ CONVENTIONAL, BACKUPMODEL_ SNAPSHOT

no

BACKUPMODEL_ CONVENTIONAL

Valid only for restore. Indicates whether the backup was originated from a snapshot method

BATCHSIZE

integer

no

1

Number of operations to start up simultaneously. Applies to all of the operations in the batch file. Must appear before the end of the first operation. Range is 1-10.

BLOCKSIZE

integer

no

0

Applicable for backup operations only. Block size is calculated as 512 bytes * 2BLOCKSIZE. Range is 1-7.

BROWSECLIENT (Same as ALTCLIENT)

string

no

none

Restores images from a host other than the local host.

BUFFERS

integer

no

1

Number of buffers per stripe. Range is 1-32.

CLOAKEDBACKUP

TRUE or FALSE

no

FALSE

Applies only to Snapshot Client database backups. If TRUE, the backup will not be recorded by SQL Server and therefore cannot be the basis for any subsequent differential backup. See Using copy-only or cloaked snapshot backups to impact how differentials are based (SQL Server 2000 and SQL Server 2005)” on page 141.

CONSISTENCYCHECK

FULLINCLUDINGINDICES, FULLEXCLUDINGINDICES, PHYSICALCHECKONLY, CHECKCATALOG

no

none

Performs the specified consistency check after the restore has been completed.

Document info
Document views723
Page views723
Page last viewedMon Jan 23 06:50:35 UTC 2017
Pages200
Paragraphs4189
Words49499

Comments