X hits on this document

521 views

0 shares

0 downloads

0 comments

63 / 200

Using NetBackup for SQL Server Using the NetBackup for MS SQL Client interface

One distinct advantage of the SQL Server Scheduler is that you can create scripts for database maintenance operations which will be initiated as a result of database events that you define. For example, you can create a script that initiates dbbackex, telling it to back up a particular transaction log, and then create an alert which invokes that script when the transaction log for this database becomes full.

Note: If you use dbbackex through a client-based scheduler, specify the -np option to ensure that a message box is not generated. However, before using the scheduler with dbbackex, try the dbbackex syntax on the console without the

  • -

    np option in order to test for the successful completion of the batch file that

you have created for your operation.

Using the NetBackup for MS SQL Client interface

The instructions in this topic describe how to use the NetBackup for MS SQL Client interface to perform NetBackup operations on SQL Server.

Starting the NetBackup MS SQL Client for the first time

To start the NetBackup MS SQL Client for the first time

1

From the Windows Start menu, choose Programs > Veritas NetBackup > NetBackup Agents > NetBackup MS SQL Client.

2 3

When prompted to provide the login parameters, click OK.

In the the SQL Server connection properties dialog box, select the SQL Server host and instance that you want to log into.

4 5

Click Apply Click Close.

Note: For subsequent sessions, the agent will remember the login parameters you provided for that Windows account.

Selecting the SQL host and instance

Use this procedure to set which SQL Server host and instance that you want the NetBackup MS SQL Client to access when it logs into SQL Server.

63

Document info
Document views521
Page views521
Page last viewedThu Dec 08 20:38:50 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments