About automatic retry of unsuccessful SQL Server backups
NetBackup for SQL Server provides the following options to retry unsuccessful backup attempts.
Automatic retry | NetBackup for SQL Server keeps track of the unsuccessful backups that may have resulted from the execution of a batch file. When the initial backup attempt is complete, the agent rewrites the batch file, including only those operations that failed. The rewritten batch file is launched automatically. |
Manual retry |
A manual retry is similar to an automatic retry except that NetBackup does not launch the rewritten batch file. Instead it is written to the install_path\dbext\mssql\temp directory. The user can then choose when to run the new batch file. |
To use automatic retry, add the following line to your batch file.
RESTARTTYPE AUTO
By default, the unsuccessful backups are retried one time automatically after 60 seconds. To change the delay following the unsuccessful attempt, then add the following to your batch file.
RESTARTWAITSECONDS <integer>
You can also specify the number of retries. Add the following to your batch file.
NUMRESTARTS <1 to 9>
To use manual retry, add the following line to your batch file.
RESTARTTYPE MANUAL
Note:
All of the keyword-value pairs that are described in this topic are only permitted in the first operation of the batch file.