CAPITULO III: ANÁLISIS DE LOS RESULTADOS
3.1. Análisis e interpretación de los resultados del diagnóstico
Table 3-1describes the keywords and values that can be used in batch files.
Table 3-1 Keywords and values used in batch files
Description Default
Required?
Values Keyword
Restores the images from a host other than the local host. Configuring NetBackup for SQL Server About using batch files with NetBackup for SQL Server
Table 3-1 Keywords and values used in batch files (continued)
Valid only for restore.
Indicates whether the backup was originated from a snapshot method all of the operations in the batch file. Must appear before the end of the first operation. Range is 1-10.
1 no
integer BATCHSIZE
Applicable for backup operations only. Block size is calculated as 512 bytes * 2BLOCKSIZE. Range is 0-7.
0 no
integer BLOCKSIZE
Restores the images from a host other than the local host. consistency check after the restore has been completed.
none
If TRUE, SQL Server creates an out-of-band backup so that it does not interfere with the normal backup sequence. The default value is FALSE except for full database persistent frozen image backups.
See“Using copy-only snapshot backups to affect how differentials are based”
on page 112. Configuring NetBackup for SQL Server About using batch files with NetBackup for SQL Server
Table 3-1 Keywords and values used in batch files (continued)
Name of database. For backup operations, specify value $ALL to designate all databases (except for
You can specify MSSQL only.
MSSQL no
MSSQL DBMS
ODBC data source name.
Deprecated.
(SQL 2005 and later) Enables SQL Server Service Broker after a restore operation. To take effect, RECOVERED STATEmust be set to RECOVERED. Include this keyword in each individual RESTORE that is specified in the batch file.
none yes
TRUE ENDOPER
Name of a database to exclude when DATABASE
$ALLis specified in a batch operation
EXCLUDEcan be used in a batch file only if DATABASE
$ALLis used. Configuring NetBackup for SQL Server About using batch files with NetBackup for SQL Server
Table 3-1 Keywords and values used in batch files (continued)
The number of databases that are snapped as a single SQL Server backup image.
See“About NetBackup Snapshot Client for SQL Server”on page 105.
none no
integer between 1 and 32 GROUPSIZE
Tells NetBackup whether to consider the candidacy of alternate buffer method.
This parameter specifies the number of separate streams into which the backup request is sub-divided.
none no
integer MAXRESTARTSETS
Maximum transfer size is calculated as 64 kilobytes bytes * 2MAXTRANSFERSIZE. Range is 0-6.
0 no
integer MAXTRANSFERSIZE
Specifies a filegroup name.
Used for restore types PARTIALand MOVE. image for the restore operations. See note for NBSERVER.
* Required for restore operations.
none yes*
string NBIMAGE
If the NetBackup policy has several Application Backup Policy schedules, use NBSCHEDto select amongst them. Configuring NetBackup for SQL Server About using batch files with NetBackup for SQL Server
Table 3-1 Keywords and values used in batch files (continued) 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 that is specified at
Number of buffers per stripe.
Range is 1-32.
The number of times to retry a backup if RESTARTTYPE AUTOis specified. Use this keyword only once in the batch file and in the first operation of the batch file.
1 no
NUMRESTARTS 1-9
Specifies a file or a filegroup name for file or for filegroup backups and restores,
* If OBJECTTYPE= FILE or FILEGROUP.
none yes*
string OBJECTNAME
Specifies the object you want to back up or restore, a database, transaction log, filegroup, or file.
Type of operation, either backup or restore.
BACKUP BACKUP, RESTORE no
OPERATION
Specifies a page ID for a page restore operation.
none Page ID no
PAGE
32 Configuring NetBackup for SQL Server About using batch files with NetBackup for SQL Server
Table 3-1 Keywords and values used in batch files (continued) perform a partial backup or restore.
FALSE TRUE, FALSE no
PARTIAL
Password for logging into SQL Server. This keyword is ignored you use integrated security.
null no
string PASSWORD
RECOVEREDmeans that the database should be restored to the recovered state.
NOTRECOVEREDmeans that it should remain in the loading state following the restore. STANDBY means that the database should be restored to standby state. If STANDBYis used, then the STANDBYPATHkeyword is also required. TRUE and FALSE, when used as values for RECOVEREDSTATE, are
Specify transaction log mark.
none no
string RESTOREBEFOREMARK
Specify transaction log mark.
none no
string RESTOREBEFOREMARK AFTERTIME
Tells NetBackup to use the SQL Server replace option on a restore. perform a page restore operation.
FALSE TRUE, FALSE no
RESTOREPAGES
Specify transaction log mark.
none no
string RESTORETOMARK
Specify transaction log mark.
none Configuring NetBackup for SQL Server About using batch files with NetBackup for SQL Server
Table 3-1 Keywords and values used in batch files (continued)
Full= Full database restore, Partial = Partial database restore, Move = Database move
RESTORETYPEis 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 PARTIALmust specify all of the filegroups in the database whose backup image is referenced by the NBIMAGEkeyword.
no FULL FULL, PARTIAL, MOVE
RESTORETYPE
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.
none AUTO, MANUAL no
RESTARTTYPE
See RESTARTTYPE.
RETRYTYPE
The time to make a second attempt following a backup failure. Use this keyword only once in the batch file and in the first operation of the batch file. Configuring NetBackup for SQL Server About using batch files with NetBackup for SQL Server
Table 3-1 Keywords and values used in batch files (continued)
Tells NetBackup to do the recovery of a persistent frozen image backup using the volume rollback method.
FALSE TRUE,FALSE no
ROLLBACKVOLUME
Name of SQL Server host.
If SQLHOST is not specified in a batch file operation, then the SQL Server host is obtained from HKEY_ then the default SQL Server instance is assumed for the SQL Host.
no string
SQLHOST
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 SQLHOSTor SQLINSTANCE Configuring NetBackup for SQL Server About using batch files with NetBackup for SQL Server
Table 3-1 Keywords and values used in batch files (continued)
Specify a fully- qualified file path to use for the standby redo log.
The datetime string is formatted as recovery of a transaction log.
The datetime string is formatted as
Used for restoring a database that was backed up using a grouped Snapshot Client snapshot.
STORAGEIMAGEidentifies the image with which the physical files are associated.
none no
string STORAGEIMAGE
Number of stripes. Range is 1-32. for each MOVE keyword. Also must sequentially follow each MOVE entry. The value may be delimited with single quotes. Configuring NetBackup for SQL Server About using batch files with NetBackup for SQL Server
Table 3-1 Keywords and values used in batch files (continued)
SQL Server transaction log backup options.
If NOTRUNC is not selected, then the transaction log can be backed up and truncated.
If TAILLOG is selected, the tail log is backed up and restored.
none NOTRUNC, TAILLOG no
TRXOPTION
User ID for logging into SQL Server. This keyword is ignored you use integrated security.
no sa string
USERID
Timeout interval for SQL Server Virtual Device
Tells SQL Server to verify a backup image but not to restore it.
FALSE no
TRUE,FALSE VERIFYONLY
This option is only valid for the 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.
no NONE NONE, STOPONERROR
CONTINUEAFTERERROR VERIFYOPTION