X hits on this document

763 views

0 shares

0 downloads

0 comments

130 / 200

130

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

Performing restores in a cluster with a multi-NIC connection

To perform restores of SQL Server in a multi-NIC, cluster environment, you need to specify the public name of the virtual SQL Server host in the SQL Server connection properties dialog box and both the virtual SQL Server host name and the private interface name of the virtual SQL Server host in the Browse History Options dialog box. You also need to create a batch file for restores and manually edit it to include the private name of the virtual SQL Server.

To perform restores

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).

Click Apply and Close. Choose File > Restore SQL Server objects. In the Backup History Options dialog box, do the following.

a

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

b

In the Source Client box, specify the private name of the virtual SQL Server (VIRTSQL-NB).

4 5 6

7

Click OK.

8

Select the databases to restore.

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

9 10

Select the desired restore options. From the Restore script options, choose Save.

11 Click Restore. A batch file similar to the following is generated.

OPERATION RESTORE OBJECTTYPE DATABASE DATABASE "ACCOUNTING" NBIMAGE "SQLHOST1.MSSQL7.VIRTSQL.db.ACCOUNTING.~.7.001of001.20040306111309..C" SQLHOST "VIRTSQL" NBSERVER "THOR"

Document info
Document views763
Page views763
Page last viewedTue Jan 24 13:58:41 UTC 2017
Pages200
Paragraphs4189
Words49499

Comments