Performing restores of a SQL Server cluster when you have multiple NICs
To perform restores of a SQL Server cluster in a multi-NIC environment, you need to do the following:
Connect to virtual SQL Server host using the public name of the host.
To browse for backup images, specify public name of the virtual SQL Server for the name. Specify the private name of the virtual SQL Server for the .
Create a batch file for the restore and manually edit it to include the private name of the virtual SQL Server.
If you do not have a cluster environment, you must follow a different procedure:
To perform restores of a cluster when you have multiple NICs
- On a specific node in the cluster, open the NetBackup for SQL Server interface.
- Select 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.
- Select File > Restore SQL Server objects.
- In the Backup History Options dialog box, specify the following.
SQL Host
Public name of the virtual SQL Server (
virtsql).Source Client
Private name of the virtual SQL Server (
virtsql-NB). - Click OK.
- Select the databases to restore.
Note:
Do not try to perform an immediate restore from the restore dialog box. The generated batch files must be modified before they can be run successfully.
- Select the restore options.
- From the Restore script options, select Save.
- Click Restore.
The NetBackup MS SQL Client generates a batch file that is similar to the following.
OPERATION RESTORE OBJECTTYPE DATABASE DATABASE "ACCOUNTING" NBIMAGE "SQLHOST1.MSSQL7.VIRTSQL.db.ACCOUNTING.~.7.001of001.20040306111309..C" SQLHOST "VIRTSQL" NBSERVER "THOR" BROWSECLIENT "VIRTSQL" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE RECOVERED ENDOPER TRUE
- Change the line value that is associated with BROWSECLIENT from the public name of the virtual SQL Server to the private name.
OPERATION RESTORE OBJECTTYPE DATABASE DATABASE "ACCOUNTING" NBIMAGE "SQLHOST1.MSSQL7.VIRTSQL.db.ACCOUNTING.~.7.001of001.20040306111309..C" SQLHOST "VIRTSQL" NBSERVER "THOR" BROWSECLIENT "VIRTSQL-NB" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE RECOVERED ENDOPER TRUE
- Select File > Manage script files.
- Select the modified batch file and click Start.