Review the following information before you create and use batch files:
A batch file consists of a series of operations (backups and restores) which by default are run in sequence.
Each operation consists of a series of <keyword value> pairs, which completely define the total operation.
The keyword is not case sensitive but the value is. Generally, you can code both the keyword and value in uppercase. The exception is that if you use the NBIMAGE keyword option, the value must be specified exactly as it is stored by NetBackup server .
With the exception of the BATCHSIZE, GROUPSIZE, RESTARTTYPE, NUMRESTARTS, and RESTARTWAITSECONDS parameters, <keyword value> pairs are not global. If you use BATCHSIZE, GROUPSIZE, RESTARTTYPE, NUMRESTARTS, or RESTARTWAITSECONDS then it must appear only once in your batch file and it must appear in the first operation.
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.
Within an operation, the <keyword value##gt## pairs may appear in any order except that each operation must be terminated by ENDOPER TRUE.
You can include comment lines in your batch file by placing a hash mark ('#') in the first column.
STOPAT, RESTORETOMARK, RESTORETOMARKAFTERTIME, RESTOREBEFOREMARK,and RESTOREBEFOREMARKAFTERTIME are mutually exclusive restore parameters. If either RESTORETOMARKAFTERTIME or RESTOREBEFOREMARKAFTERTIME are used, then the batch file must also specify a datetime string with the keyword STOPAFTER.