This procedure describes how to restore the SQL Server databases after disaster recovery.
To restore the SQL Server databases
If SQL Server is configured in a cluster, you must start SQL Server in single-user mode before you restore the SQL databases.
Locate all the media that is required to perform the restore operations.
Select the backup image that contains the copy of the master database you want to restore.
If SQL Server is configured in a cluster, restart the SQL Server service after the restore has completed.
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