To perform restores of a cluster when you have multiple NICs

1. On a specific node in the cluster, open the NetBackup for SQL Server interface.
2. Select File > Set SQL Server connection properties.
3. In the Host box, specify the public name of the virtual SQL Server host (virtsql).
4. Click Apply and Close.
5. Select File > Restore SQL Server objects.
6. 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).

7. Click OK.
8. 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.

9. Select the restore options.
10. From the Restore script options, select Save.
11. 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

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

13. Select File > Manage script files.
14. Select the modified batch file and click Start.