Using NetBackup for SQL Server Using batch files
Keywords and values used in batch files (continued)
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.
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.
Tells NetBackup to do the recovery of a persistent frozen image backup using the volume rollback method.
Name of SQL Server host.
Note: 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.
Name of the SQL Server instance or for backup operations specify $ALL to designate all SQL Server instances including the default instance.
Note: If SQLINSTANCE $ALL is used, then it must appear in the first operation of the batch file. Each operation in the batch file will be performed for all SQL Server instances on the client where the batch file is executed. Also, it is not necessary to specify a SQLHOST or SQLINSTANCE on any subsequent operations.
Specify a fully- qualified file path to
use for the standby redo log.
(SQL Server 2000 or later) Specifies datetime for RESTORETOMARK options. The datetime string is formatted as YYYY/MMDDHH:MM:SS.