X hits on this document

559 views

0 shares

0 downloads

0 comments

129 / 200

Using NetBackup for SQL Server with clustering solutions Using SQL Server in a cluster with a multi-interface network connection

To perform backups

1

On either SQLHOST1 or SQLHOST2, open the NetBackup for SQL Server interface.

2 3

Choose File > Set SQL Server connection properties.

In the Host box, specify the public name of the virtual SQL Server host (VIRTSQL).

4 5 6 7

Click Apply and Close. Choose File > Backup SQL Server objects. Select the databases to back up. Select the desired backup options.

Note: Do not attempt to perform an immediate backup from the backup dialog box. The generated batch files must be modified before they can be run successfully.

8 9

From the Backup script options, choose Save.

Click Backup. A batch file similar to the following will be created:

OPERATION BACKUP DATABASE "ACCOUNTING" SQLHOST "VIRTSQL" NBSERVER "THOR" BROWSECLIENT "VIRTSQL" MAXTRANSFERSIZE 0 BLOCKSIZE 7 ENDOPER TRUE

10 Change the line value associated with BROWSECLIENT from the public virtual SQL Server name to the private name.

OPERATION BACKUP DATABASE "ACCOUNTING" SQLHOST "VIRTSQL" NBSERVER "THOR" BROWSECLIENT "VIRTSQL-NB" MAXTRANSFERSIZE 0 BLOCKSIZE 7 ENDOPER TRUE

11 Place the modified batch file on both nodes in the cluster so that it will be available for scheduled backups, regardless of which node is active when a backup is initiated.

129

Document info
Document views559
Page views559
Page last viewedSat Dec 10 16:44:23 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments