X hits on this document

508 views

0 shares

0 downloads

0 comments

108 / 200

108

Using NetBackup for SQL Server Using batch files

Table 5-12

Keywords and values used in batch files (continued)

Keyword

Values

Required?

Default

Description

no

See description

If TRUE, an out-of-band backup will be created by SQL Server so that it does not interfere with the normal backup sequence. The default value is FALSE except for full database persistent frozen image backups. COPYONLY is only available for SQL Server 2005 database, differential, and transaction log backups.

yes

none

Name of database. For backup operations, specify value $ALL to designate all databases (except for tempdb.)

no

MSSQL

You can specify MSSQL only.

no

saved from GUI user session

ODBC data source name. Deprecated.

no

none

Specifies INCREMENTAL restoring from an incremental backup.

yes

none

Terminates each operation specified in the batch file.

no

none

Name of a database to exclude when DATABASE $ALL is specified in a batch operation

DATABASE

string

DBMS

MSSQL

DSN

string

GROUPSIZE

integer between 1 and 32

no

none

INHIBITALTBUFFER METHOD

TRUE, FALSE

no

FALSE

COPYONLY

TRUE or FALSE

DUMPOPTION

INCREMENTAL

ENDOPER

TRUE

EXCLUDE

string

Note: EXCLUDE can be used in a batch file only if DATABASE $ALL is used.

The number of databases that will be snapped as a single SQL Server backup image. See “Using NetBackup for SQL Server with Snapshot Client” on page 133.

Tells NetBackup whether to consider the candidacy of alternate buffer method.

Document info
Document views508
Page views508
Page last viewedThu Dec 08 10:55:31 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments