DOCUMENTATION: How to use NetBackup 6.0 to backup Microsoft SQL databases on a SQL server with multiple SQL instances.

Article:TECH50665  |  Created: 2007-01-29  |  Updated: 2009-01-22  |  Article URL http://www.symantec.com/docs/TECH50665
Article Type
Technical Solution

Product(s)

Environment

Issue



DOCUMENTATION: How to use NetBackup 6.0 to backup Microsoft SQL databases on a SQL server with multiple SQL instances.

Solution



Manual: Veritas NetBackup 6.0 for Microsoft SQL Server System Administrator's Guide for Windows, Page: 57

Modification Type: Supplement.

Modification:
On Microsoft SQL servers with multiple SQL instances, it is necessary to create and configure at least one batch file per SQL instance in order to successfully backup all databases using NetBackup.  In order to configure the batch files, it is necessary to log into each SQL instance and create the batch file.  

1. Open the NetBackup MS SQL Client, and from the "File" menu, select "Set SQL Server connection properties".  (See Figure 1.)

Figure 1
 

2. On the "SQL Server connection properties" screen, start by specifying the SQL server's name (in the "Host" box) and selecting the first instance name (usually default) and entering that under "Instance".  (See Figure 2.)  After confirming the Userid and password (if necessary) click on "Apply" and then "Close".

Figure 2
 

3. Then, from the "File" menu, select "Backup SQL Server objects" (see Figure 3).  

Figure 3
 

4. Create a batch file for the first instance by selecting the databases in the right hand window (see Figure 4), specifying the "Save" option under "Backup Script" section, and then clicking on the "Backup" button.

Figure 4
 

4. Repeat Steps 1 through 4 for all other SQL instances.  

Once all the necessary batch files have been created, include all batch file names in the NetBackup MS-SQL Policy which backs up the server.  The backup will now capture the specified databases on the specified instances.



Legacy ID



287235


Article URL http://www.symantec.com/docs/TECH50665


Terms of use for this information are found in Legal Notices