ALTCLIENT (Same as BROWSECLIENT)
|
string
|
no
|
none
|
Restores images from a host other than the local host.
|
BACKUPMODEL
|
BACKUPMODEL_
CONVENTIONAL,
BACKUPMODEL_ SNAPSHOT
|
no
|
BACKUPMODEL_CONVENTIONAL
|
Valid only for restore. Indicates whether the backup was
originated from a snapshot method
|
BATCHSIZE
|
integer
|
no
|
1
|
Number of back up operations to start up simultaneously. Applies
to all of the operations in the batch file. Must appear before the
end of the first operation. Range is 1-10.
|
BLOCKSIZE
|
integer
|
no
|
0
|
Applicable for backup operations only. Block size is calculated
as 512 bytes * 2BLOCKSIZE.
Range is 1-7.
|
BROWSECLIENT (Same as ALTCLIENT)
|
string
|
no
|
none
|
Restores images from a host other than the local host.
|
BUFFERS
|
|
|
|
See NUMBUFS.
|
CLOAKEDBACKUP
|
TRUE or FALSE
|
no
|
FALSE
|
Applies only to Snapshot Client database backups of SQL 2000. If
TRUE, the backup is not recorded by
SQL Server and therefore cannot be the basis for any subsequent
differential backup.
|
CONSISTENCYCHECK
|
FULLINCLUDINGINDICES,
FULLEXCLUDINGINDICES, PHYSICALCHECKONLY, CHECKCATALOG
|
no
|
none
|
Performs the specified consistency check after the restore has
been completed.
|
COPYONLY
|
TRUE or
FALSE
|
no
|
See description
|
If TRUE, an out-of-band backup is
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 or later database, differential, and
transaction log backups.
|
DATABASE
|
string
|
yes
|
none
|
Name of database. For backup operations, specify value
$ALL to designate all databases
(except for tempdb.)
|
DBMS
|
MSSQL
|
no
|
MSSQL
|
You can specify MSSQL only.
|
DSN
|
string
|
no
|
saved from GUI user session
|
ODBC data source name. Deprecated.
|
DUMPOPTION
|
INCREMENTAL
|
no
|
none
|
Specifies INCREMENTAL restoring
from an incremental backup.
|
ENDOPER
|
TRUE
|
yes
|
none
|
Terminates each operation specified in the batch file.
|
EXCLUDE
|
string
|
no
|
none
|
Name of a database to exclude when DATABASE $ALL is specified in a batch
operation
EXCLUDE can be used in a batch file
only if DATABASE $ALL is used.
|
GROUPSIZE
|
integer between 1 and 32
|
no
|
none
|
The number of databases that will be snapped as a single SQL
Server backup image.
|
INHIBITALTBUFFER METHOD
|
TRUE, FALSE
|
no
|
FALSE
|
Tells NetBackup whether to consider the candidacy of alternate
buffer method.
|
MAXRESTARTSETS
|
integer
|
no
|
none
|
Use MAXRESTARTSETS to enable file
checkpointing. The valid range is 2 to 32. This parameter specifies
the number of separate streams into which the backup request is
sub-divided.
|
MAXTRANSFERSIZE
|
integer
|
no
|
0
|
Maximum transfer size is calculated as 64 kilobytes bytes *
2MAXTRANSFERSIZE. Range is
1-6.
|
MOVE
|
file group
|
no
|
none
|
Specifies a filegroup name. Used for restore types PARTIAL and MOVE.
|
NBIMAGE
|
string
|
yes*
|
none
|
Specifies a NetBackup image for the restore operations. See note
for NBSERVER.
* Required for restore operations.
|
NBSCHED
|
string
|
no
|
none
|
If the NetBackup policy has several Application Backup Policy
schedules, use NBSCHED to select
amongst them.
|
NBSERVER
|
string
|
no
|
none
|
Specifies which master server to use for the backup or restore
operation.
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\NetBackup
for Microsoft SQL Server\DEFAULT_SQL_NB_MASTER_SERVER.
|
|
NUMBUFS
|
integer
|
no
|
1
|
Number of buffers per stripe. Range is 1-32.
|
NUMRETRIES
|
|
|
|
See NUMRESTARTS.
|
NUMRESTARTS
|
1-9
|
no
|
1
|
The number of times to retry a backup if RESTARTTYPE AUTO is specified. Use this keyword
only once in the batch file and in the first operation of the batch
file.
|
OBJECTNAME
|
string
|
yes*
|
none
|
Specifies a file or filegroup name for file/filegroup backups
and restores,
* If OBJECTTYPE= FILE or
FILEGROUP.
|
OBJECTTYPE
|
DATABASE, TRXLOG, FILEGROUP, FILE
|
no
|
DATABASE
|
Specifies whether you are backing up or restoring a database,
transaction log, filegroup, or file.
|
OPERATION
|
BACKUP, RESTORE
|
no
|
BACKUP
|
Type of operation, either backup or restore.
|
PAGE
|
Page ID
|
no
|
none
|
SQL Server 2005 or later. Specifies a page ID for a page restore
operation.
|
PARTIAL
|
TRUE, FALSE
|
no
|
FALSE
|
SQL Server 2005 or later. Specifies NetBackup perform a partial
backup or restore.
|
PASSWORD
|
string
|
no
|
null
|
Password for logging into SQL Server.
|
RECOVERED STATE
|
RECOVERED, STANDBY, NOTRECOVERED, TRUE,
FALSE
|
no
|
RECOVERED
|
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.
|
RESTOREBEFOREMARK
|
string
|
no
|
none
|
Specify transaction log mark.
|
RESTOREBEFOREMARK AFTERTIME
|
string
|
no
|
none
|
Specify transaction log mark.
|
RESTOREOPTION
|
REPLACE
|
no
|
none
|
Tells NetBackup to use the SQL Server replace option on a
restore.
|
RESTOREPAGES
|
TRUE, FALSE
|
no
|
FALSE
|
SQL Server 2005 or later. Specifies that NetBackup perform a
page restore operation.
|
RESTORETOMARK
|
string
|
no
|
none
|
Specify transaction log mark.
|
RESTORETOMARK AFTERTIME
|
string
|
no
|
none
|
Specify transaction log mark.
|
RESTORETYPE
|
FULL, PARTIAL, MOVE
|
no
|
FULL
|
Full = Full database restore,
Partial = Partial database restore,
Move = Database move
RESTORETYPE is applicable only to
RESTORE database operations. 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.
|
RESTARTTYPE
|
AUTO, MANUAL
|
no
|
none
|
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.
|
RETRYTYPE
|
|
|
|
See RESTARTTYPE.
|
RESTARTWAITSECONDS
|
integer number
|
no
|
60
|
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.
|
RETRYWAITSECONDS
|
|
|
|
See RESTARTWAITSECONDS.
|
ROLLBACKVOLUME
|
TRUE,FALSE
|
no
|
FALSE
|
Tells NetBackup to do the recovery of a persistent frozen image
backup using the volume rollback method.
|
SQLHOST
|
string
|
no
|
|
Name of SQL Server host.
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
|
|
Name of the SQL Server instance. Or for backup operations
specify $ALL to designate all SQL Server instances including the
default instance.
If SQLINSTANCE $ALL is used, then it must appear in the first
operation of the batch file. Each operation in the batch file is
performed for all SQL Server instances on the client where the
batch file is executed. Also, it is not necessary to specify an
SQLHOST or SQLINSTANCE on any subsequent operations.
|
STANDBYPATH
|
string
|
no
|
none
|
Specify a fully- qualified file path to use for the standby redo
log.
|
STOPAFTER
|
datetime string
|
no
|
none
|
Specifies datetime for RESTORETOMARK options. The datetime string is
formatted as YYYY/MMDDHH:MM:SS.
|
STOPAT
|
datetime string
|
no
|
none
|
Specifies point-in-time recovery of a transaction log. The
datetime string is formatted as YYYY/MMDDHH:MM:SS.
|
STORAGEIMAGE
|
string
|
no
|
none
|
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.
|
STRIPES
|
integer
|
no
|
1
|
Number of stripes. Range is 1-32.
|
TO
|
file path
|
no
|
none
|
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.
|
TRACELEVEL
|
MIN, MID, MAX
|
no
|
MIN
|
Trace level.
|
TRXOPTION
|
NOTRUNC, TRUNCONLY, TAILLOG
|
no
|
none
|
SQL Server transaction log backup options.
Note:
|
TRUNCONLY applies only to SQL Server 2000.
TAILLOG only applies to SQL Server 2005 or later.
|
If neither NOTRUNC nor TRUNCONLY is selected, then the transaction log
can be backed up and truncated. If TAILLOG is selected, the tail log is backed up and
restored.
|
USERID
|
string
|
no
|
sa
|
User ID for logging into SQL Server.
|
VDITIMEOUTSECONDS
|
integer
|
no
|
300
|
Timeout interval for SQL Server Virtual Device Interface
|
VERIFYONLY
|
TRUE,FALSE
|
no
|
FALSE
|
(SQL Server 2005 or later) Tells SQL Server to verify a backup
image but not to restore it.
|
VERIFYOPTION
|
NONE, STOPONERROR
CONTINUEAFTERERROR
|
no
|
NONE
|
(SQL Server 2005 or later) This option is only valid for
databases that have an active page. STOPONERROR performs verification and stops if a
verification error occurs. CONTINUEAFTERERROR performs verification but
continues if a verification error occurs.
|