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
From the Windows Start menu, choose Programs > Veritas NetBackup > NetBackup Agents > NetBackup MS SQL Client.
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.
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.