Disaster recovery Disaster recovery of SQL Server databases
To rebuild the master database
Run the Rebuild Master utility (\SQL directory\bin\Rebuildm.exe).
Note: See the Microsoft SQL Server official documentation for information on how to use rebuildm.exe.
When the rebuild is complete, restart the SQL Server services if necessary.
To start SQL Server in single-user mode
Note: SQL agent will automatically put the database in single-user mode for restores of non-clustered SQL Server 2000 or higher.You need to start SQL Server in single-user mode only if SQL Server is configured in a cluster or if you have a version of SQL Server 7.0.
In the Windows Control Panel, open Services.
Select the MSSQLServer service
Type the following in the Startup Parameters box:
To restore the SQL databases
If you have SQL 7.0, you must start SQL Server in single-user mode before restoring the SQL databases. See the previous procedure for details.
Open the NetBackup for SQL Client interface.
Locate all the media required to perform the restore operations. Choose File > Restore SQL Server objects.
Select the backup image that contains the copy of the master database to be restored.