When you recover SQL manually, you must first restore the Windows server from full system backups. After recovery of the Windows computer is complete, or after the new server installation is available, you can recover the SQL databases.
See About manual disaster recovery of Windows computers.
In order to restore SQL databases, SQL must be running; however, SQL cannot be started unless the master and model databases are present.
You can restore the master and model databases and start SQL using one of the following methods:
-
Rename the files created by Backup Exec that replace the master and model databases. After the master and model databases are present on SQL, you must start SQL, restore the master database with the Automate master database restore option, and then restore all other databases.
-
Run the Rebuild Master utility (\Program Files\Microsoft SQL Server\80\Tools\Binn\rebuildm.exe for SQL 2000.
This topic only details how to restart SQL by using the copies of the master and model databases made by Backup Exec. For more information on the Rebuild Master utility, or on reinstalling SQL, refer to your MS SQL documentation.
If you are restoring to a new SQL installation, start with the restore of the master database.