To perform restores in a cluster with a multi-NIC connection

1. On either SQLHOST1 or SQLHOST2, 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, do the following.

   SQL Host	Specify the public name of the virtual SQL Server (VIRTSQL).
   Source Client	Specify the 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.

    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"
    	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 virtual SQL Server name 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.