Sharepoint Database Restore Procedure

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 Files\Common Files\Microsoft Shared\web server extensions\12\BIN

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 Files\Common Files\Microsoft Shared\Web Server Extensions\12\Logs\Upgrade.log”

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

Related posts:

1. SharePoint Browser Crash Solution One of the most common problems around the office seems to be the browser crashes when attempting to open files in a SharePoint document library.  Luckily, most of the time it is an easy fix.  Problem: Internet Explorer crashes (stops responding) when you try to open an Office document in a SharePoint document library. Scenario: [...]...
2. Proper way of moving sites between web applications Sometimes sites need to move from one location to another. Here is how you do that using the Sharepoint CLI utility stsadm. Note: Always perform in a test environment. An empty site must be in place before a cabinet file can be imported 1. Use MOSS07′s sts_adm.exe tool on test server located in directory: C:\Program [...]...
3. SharePoint deployment strategies overview Companies considering a deployment of Microsoft Office SharePoint Server should review a number of key factors to cost-effectively engage their organization with the product. The following post will familiarize you with some of the typical deployment strategies in a high level overview. There are many methods to consider when deploying a SharePoint solution within any [...]...
4. How to create and add a new LOB application definition using BDC Metaman Line of Business applications can be integrated into SharePoint 2007 using the Business Data Catalog. The out of box Microsoft tool is OK to use, but for this article we will be working with the Free Trial version of BDC Metaman by Lightning Tools. It is superior in many ways to the Microsoft tool and [...]...
5. Import Outlook Calendar to SharePoint SharePoint makes it very easy to export Calendars from SharePoint to Outlook.  But what if you have an Outlook calendar that you want on SharePoint?  This becomes more difficult and you could quickly find yourself lost on how to complete this task.  Don’t worry though, it’s not that hard.  The following article will explain a [...]...