X hits on this document

512 views

0 shares

0 downloads

0 comments

109 / 200

Using NetBackup for SQL Server Using batch files

109

Table 5-12

Keywords and values used in batch files (continued)

Keyword

Values

Required?

Default

Description

MAXTRANSFERSIZE

integer

no

MOVE

file group

no

NBIMAGE

string

yes

NBSCHED

string

no

NUMRETRIES

1-9

no

NBSERVER

string

no

0

Maximum transfer size is calculated as 64 kilobytes bytes * 2MAXTRANSFERSIZE. Range is 1-6.

none

Specifies a filegroup name. Used for restore types PARTIAL and MOVE.

none

Specifies a NetBackup image for the restore operations. See note below.

* Required for restore operations.

none

If the NetBackup policy has several Application Backup Policy schedules, use NBSCHED to select amongst them.

1

The number of times to retry a backup if RETRYTYPE AUTO is specified. Use this keyword only once in the batch file and in the first operation of the batch file.

none

Specifies which master server to use for the backup or restore operation. Also see following note.

*

OBJECTNAME

string

yes

OBJECTTYPE

DATABASE, TRXLOG,

no

FILEGROUP, FILE

OPERATION

BACKUP, RESTORE

no

PAGE

Page ID

no

Note: If NBSERVER is not specified in a batch file operation, the master server defaults to the name specified at HKEY_CURRENT_USER\Software\VERITAS\NetBackup\ N e t B a c k u p f o r M i c r o s o f t S Q L S e r v e r \ D E F A U L T _ S Q L _ N B _ M A S T E R _ S E R V E R .

none

SQL Server 2005 only. Specifies a page ID for a page restore operation.

DATABASE

Specifies whether you are backing up or restoring a database, transaction log, filegroup, or file.

BACKUP

Type of operation, either backup or restore.

Specifies a file or filegroup name for file/filegroup backups and restores,

  • *

    If OBJECTTYPE= FILE or

FILEGROUP.

*

none

Document info
Document views512
Page views512
Page last viewedThu Dec 08 14:19:16 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments