Restoring the SQL Server databases

This procedure describes how to restore the SQL Server databases after disaster recovery.

To restore the SQL Server databases

  1. If SQL Server is configured in a cluster, you must start SQL Server in single-user mode before you restore the SQL databases.

  2. Open the NetBackup for SQL Client interface.

  3. Locate all the media that is required to perform the restore operations.

  4. Select File > Restore SQL Server objects.

  5. Select the backup image that contains the copy of the master database you want to restore.

    Select only the master database at this time.

  6. Click Restore.

  7. If SQL Server is configured in a cluster, restart the SQL Server service after the restore has completed.

  8. Continue restoring 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, Symantec recommends that you perform a full database backup as soon as possible.

More Information

Starting SQL Server in single-user mode

Using the NetBackup for SQL Client interface