Using NetBackup for SQL Server Using batch files
Keywords and values used in batch files (continued)
NONE, STOPONERROR CONTINUEAFTERERROR
(SQL Server 2005) This option is only valid for databases that have an active page. STOPONERROR will perform verification and stop if a verification error occurs. CONTINUEAFTERERROR will perform verification but continue if a verification error occurs.
Creating a batch file
You can use any of the backup or restore dialog boxes to create a batch file containing a NetBackup for SQL Server script. This script can be executed at a later time from the Manage Scripts dialog box. Or you can launch the script from the dbbackex command line program or through the NetBackup scheduler. To see examples, refer to “Sample batch files” on page 181.
To create a batch file
Choose File > Backup SQL Server objects or File > Restore SQL Server objects.
Select the object you wish to back up or restore. Select the desired options.
See “Backup options” on page 65 or “Restore options” on page 77 for a description of the available options.
4 5 6
In the Backup script or Restore script group, choose Save. Click Backup or Restore. Specify a filename and click Save.
Note: Alternatively, in step 6 you can highlight the name of an existing file, and NetBackup will append the new script to it.
Click Yes to open and edit the batch file.