Accidents happen… If Sharepoint has crashed and your database needs to be restored, here is how you can do it; this is a high level overview.

1. Restore database to a new Database

2. Dismount content database from Site you are restoring by using the central administration admin utility from DOS on one of the Sharepoint Front-end’s or Index Server run the following command from the following location

3. C:Program FilesCommon FilesMicrosoft Sharedweb server extensions12BIN

4. stsadm -o addcontentdb -url -databasename

5. Results should be something similar to the following:

“Upgrade completed with errors. Review the upgrade.log file located in C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12LogsUpgrade.log”

The number of errors and warnings is listed at the end of the upgrade log file.