X hits on this document

395 views

0 shares

0 downloads

0 comments

112 / 200

112

Using NetBackup for SQL Server Using batch files

Table 5-12

Keywords and values used in batch files (continued)

Keyword

Values

Required?

Default

no

none

no

none

STOPAT

datetime string

STORAGEIMAGE

string

no

1

no

none

STRIPES

integer

TO

file path

no

MIN

no

none

TRACELEVEL

MIN, MID, MAX

TRXOPTION

NOTRUNC, TRUNCONLY, TAILLOG

USERID

string

VDITIMEOUTSECONDS

integer

no

sa

no

300

no

FALSE

VERIFYONLY

TRUE,FALSE

Description

Specifies point-in-time recovery of a transaction log. The datetime string is formatted as YYYY/MMDDHH:MM:SS.

Used for restoring a database that was backed up using a grouped Snapshot Client snapshot. STORAGEIMAGE identifies the image with which the physical files are associated.

Number of stripes. Range is 1-32.

Specifies a filegroup destination path. Required for each MOVE keyword. Also must sequentially follow each MOVE entry. The value may be delimited with single quotes.

Trace level.

SQL Server transaction log backup options.

Note: TRUNCONLY applies only to SQL Server 7.0 and SQL Server 2000. TAILLOG only applies to SQL Server 2005.

If neither NOTRUNC nor TRUNCONLY is selected, then the transaction log will be backed up and truncated. If TAILLOG is selected, the tail log will be backed up and restored.

Userid for logging into SQL Server.

Timeout interval for SQL Server Virtual Device Interface

(SQL Server 2005) Tells SQL Server to verify a backup image but not to restore it.

Document info
Document views395
Page views395
Page last viewedFri Dec 02 20:28:49 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments