X hits on this document

511 views

0 shares

0 downloads

0 comments

110 / 200

110

Using NetBackup for SQL Server Using batch files

Table 5-12

Keywords and values used in batch files (continued)

Keyword

Values

Required?

Default

Description

PARTIAL

TRUE, FALSE

no

FALSE

SQL Server 2005 only. Specifies that a partial backup or restore will be performed.

PASSWORD

string

no

null

Password for logging into SQL Server.

RECOVERED STATE

RECOVERED, STANDBY, NOTRECOVERED, TRUE, FALSE

no

RECOVERED

See the following note.

Note: RECOVERED means that the database should be restored to the recovered state. NOTRECOVERED means that it should remain in the loading state following the restore. STANDBY means that the database should be restored to standby state. If STANDBY is used, then the STANDBYPATH keyword is also required. TRUE and FALSE, when used as values for RECOVEREDSTATE, are synonyms for RECOVERED and NOTRECOVERED.

no

none

no

none

no

none

no

FALSE

RESTOREBEFOREMARK

string

RESTOREBEFOREMARK

string

AFTERTIME

RESTOREOPTION

REPLACE

RESTOREPAGES

TRUE, FALSE

SQL Server 2000 or later restore option. Specify transaction log mark.

SQL Server 2000 or later restore option. Specify transaction log mark.

Tells NetBackup to use the SQL Server replace option on a restore.

SQL Server 2005 only. Specifies that a page restore operation will be performed.

no

none

no

none

no

FULL

RESTORETOMARK

string

RESTORETOMARK

string

AFTERTIME

RESTORETYPE

FULL, PARTIAL, MOVE

SQL Server 2000 or later restore option. Specify transaction log mark.

SQL Server 2000 or later restore option. Specify transaction log mark.

Full = Full database restore, Partial = Partial database restore, Move = Database move

Note: RESTORETYPE is applicable only to RESTORE database operations. PARTIAL requires SQL Server 2000 or later. If MOVE is used, then the batch file should contain a series of one or more <MOVE><filegroup> and <TO><file path> sequences. If PARTIAL is used, the sequence for PARTIAL must specify all of the filegroups in the database whose backup image is referenced by the NBIMAGE keyword.

Document info
Document views511
Page views511
Page last viewedThu Dec 08 12:28:29 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments