X hits on this document

548 views

0 shares

0 downloads

0 comments

111 / 200

Using NetBackup for SQL Server Using batch files

111

Table 5-12

Keywords and values used in batch files (continued)

Keyword

Values

Required?

Default

Description

no

none

no

60

no

FALSE

no

See note

RETRYTYPE

AUTO, MANUAL

RETRYWAITSECONDS

integer number

ROLLBACKVOLUME

TRUE,FALSE

SQLHOST

string

Available only for backups. Use AUTO to automatically retry backup of failed objects. Use MANUAL to create a batch file for backing up any of the objects that were not successfully backed up. Use this keyword only once in the batch file and in the first operation of the batch file.

The time to following a backup failure before making a second attempt. Use this keyword only once in the batch file and in the first operation of the batch file.

Tells NetBackup to do the recovery of a persistent frozen image backup using the volume rollback method.

Name of SQL Server host.

Note: If SQLHOST is not specified in a batch file operation, then the SQL Server host is obtained from HKEY_CURRENT_USER\Software\VERITAS\NetBackup\NetBackup for Microsoft SQL Server\DEFAULT_SQL_HOST. If SQLINSTANCE is missing, then the default SQL Server instance is assumed for the SQL Host.

SQLINSTANCE string

no

See note

Name of the SQL Server instance or for backup operations specify $ALL to designate all SQL Server instances including the default instance.

Note: If SQLINSTANCE $ALL is used, then it must appear in the first operation of the batch file. Each operation in the batch file will be performed for all SQL Server instances on the client where the batch file is executed. Also, it is not necessary to specify a SQLHOST or SQLINSTANCE on any subsequent operations.

no

none

no

none

STANDBYPATH

string

STOPAFTER

datetime string

Specify a fully- qualified file path to

use for the standby redo log.

(SQL Server 2000 or later) Specifies datetime for RESTORETOMARK options. The datetime string is formatted as YYYY/MMDDHH:MM:SS.

Document info
Document views548
Page views548
Page last viewedSat Dec 10 09:37:15 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments