X hits on this document

417 views

0 shares

0 downloads

0 comments

113 / 200

Using NetBackup for SQL Server Using batch files

113

Table 5-12

Keywords and values used in batch files (continued)

Keyword

Values

Required?

Default

Description

VERIFYOPTION

NONE, STOPONERROR CONTINUEAFTERERROR

no

NONE

(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

1

Choose File > Backup SQL Server objects or File > Restore SQL Server objects.

2 3

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.

7

Click Yes to open and edit the batch file.

Document info
Document views417
Page views417
Page last viewedSun Dec 04 04:08:21 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments