Restore a SQL Server cluster when you have multiple NICs (NetBackup MS SQL Client)
To restore a SQL Server cluster in a multi-NIC environment with the NetBackup MS SQL Client, 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 the 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 change the BROWSECLIENT parameter to indicate the private name of the virtual SQL Server.
For a non-cluster environment, you must follow a different procedure:
To restore a SQL Server cluster when you have multiple NICs
- On a specific node in the cluster, open the NetBackup MS SQL Client.
- Select File > Set SQL Server connection properties.
- In the Host box, specify the public name of the virtual SQL Server host (
virtsql). - Select 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). - Select 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.
- Select 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 select Start.