Ransomware attackers specifically target and attempt to destroy backup systems to increase the probability of payment. Hardening your system is critical. Please ensure you have reviewed your platform security using the Security Hardening Checklist
Cohesity

COHESITY Documentation

Explore our documentation to get started, discover products & new features, access troubleshooting guides, register sources, platforms support.

Products
Data Security Alliance
Visit Cohesity.com
Demos
Support
Blogs
Developers
Partner Portals
Cohesity Community
© 2026 Cohesity, Inc. All Rights Reserved.
Terms of Use|
Privacy Policy|
Legal|
  1. Home
  2. NetBackup™ for Microsoft SQL Server Administrator's Guide
  3. Using NetBackup for SQL Server with multiple NICs
  4. Restore a SQL Server cluster when you have multiple NICs (NetBackup MS SQL Client)
NetBackup™ for Microsoft SQL Server Administrator's Guide

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 SQL Host name. Specify the private name of the virtual SQL Server for the Source Client.

  • 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

  1. On a specific node in the cluster, open the NetBackup MS SQL Client.
  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. Select 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. Select 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. 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
  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 select Start.

More Information

Restore SQL Server when you have multiple NICs (NetBackup MS SQL Client)

Options for NetBackup for SQL Server restores

Feedback

Was this page helpful?
Previous

Create a batch file for backups of a SQL Server cluster when you have multiple NICs (batch file-based policies)

Next

Performance and troubleshooting

Feedback

Was this page helpful?