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
  3. Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide
  5. Performance and troubleshooting
  7. About disaster recovery of SQL Server
  9. Recovering SQL Server databases after disaster recovery
Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide

Recovering SQL Server databases after disaster recovery

For the purposes of disaster recovery, you should only restore to a new installation of SQL Server. However, you can restore an existing installation of SQL Server with other active databases. The server should be running the same version of Windows on the same hardware platform. It also should be running the same version of SQL Server with the same service pack as the original server.

To recover SQL Server databases

  1. If you want to restore to an existing SQL Server, choose from one of the following:

    • For a new SQL Server installation or when the master database is intact, continue with step 4.

    • If the master database is corrupt, you must first rebuild the master database. Continue with step 2.

  2. Refer to the following article for instructions on how to rebuild the master database. Click the "Other Versions" drop-down list to select the correct SQL Server version.

    http://msdn.microsoft.com/en-us/library/ms144259.aspx

    Look for the information that describes how to rebuild system databases for a default instance from the command prompt.

  3. When the rebuild is complete, restart the SQL Server services if necessary.
  4. To begin the restore of the master database, start SQL Server in single-user mode.

    The procedure to start SQL Server in single-user mode is described in the following article:

    http://msdn.microsoft.com/en-AU/library/ms188236.aspx

    Click the "Other Versions" drop-down list to select the correct SQL Server version.

  5. Open the NetBackup MS SQL Client interface.
  6. Locate all the media that is required to perform the restore operations.
  7. Select File > Restore SQL Server objects.
  8. Select the backup image that contains the copy of the master database you want to restore.

    Select only the master database at this time.

  9. Click Restore.
  10. Restart the SQL Server service after the restore completes.
  11. Continue with the restore of the remaining SQL Server databases.

    Follow the instructions for restoring SQL databases, differentials, transaction logs, files, and filegroups.

    When all of the restore operations have completed successfully, then the recovery of the SQL Server databases is complete.

    After the recovery is complete, Veritas recommends that you perform a full database backup as soon as possible.

Feedback

Was this page helpful?
Previous

Preparing for disaster recovery of SQL Server

Next

Appendix A. Other configurations

Feedback

Was this page helpful?