Using SharePoint Database Explorer on SBS

Article
01/05/2007

[Today's tip comes to us courtesy of Ed Walters.]

Administrators often need to extract a small number of files or even a single file from a SharePoint database, and may not necessarily want to go through the process of an entire disaster recovery to retrieve them. SharePoint Database Explorer can be useful in cases where you have the database files, but it is inconvenient (or impossible) to restore them to a SharePoint site. Common scenarios we've seen are:

A customer has overwritten an important document in SharePoint and no local copy is available; document versioning has not been enabled for the library. The customer does not want to force users to log off the server during normal business hours. In this case, you would simply restore the database files from backup, mount them, and retrieve the documents.
During disaster recovery, if no backups other than the database files exist, we may manually extract the files from the database as a "belt and suspenders" approach to disaster recovery. This is also useful if there are any concerns about ACLs moving documents to a server in a new domain. This method is not recommended for extensive disaster recovery procedures where a large number of document libraries must be exported, but we've found it to be sufficient for many SBS deployments.
A critical change has been made to a document, and the author(s) is not sure of the date the document should be restored back to. Again, no versioning is in place. Multiple copies of the document must be recovered for comparison. It's easier to restore 3 databases and extract the document than it is to restore, mount, and extend 3 SharePoint sites.

SharePoint Database Explorer can be used with either OSQL or SQL. This tool is not supported by Microsoft.

Program Download location: https://mindsharpblogs.com/james/archive/2005/01/20/189.aspx

Database Files needed: STS_Servername_1.mdf and the STS_Servername _1_log.ldf.

Using SharePoint Database Explorer with OSQL

1. Download the SharePoint Database Explorer files

2. Extract the the files to a folder on the desktop.

3. Copy the STS_Servername_1.mdf and the STS_Servername _1_log.ldf C:\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\.

4. Attach the databases using OSQL:

osql -S servername\sharepoint –E
EXEC sp_attach_db @dbname = 'STS_SERVERNAME_1', @filename1 = 'C:\Program Files\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\STS_SERVERNAME_1.mdf', @filename2 = 'C:\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\STS_SERVERNAME_1_log.LDF'
Go

5. Open Database Explorer

6. Enter the server\instance name

For example, if you copied the database to the MSSQL$SHAREPOINT\data your instance name would be sharepoint: