The official blog for Windows Server Essentials and Small Business Server support and product group communications.
[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:
SharePoint Database Explorer can be used with either OSQL or SQL. This tool is not supported by Microsoft.
Program Download location: http://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 –EEXEC 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:
7. Select the "+" sign
8. Select the library on the left
9. It will then show you documents on the right you can export.
10. Select the different libraries to view the documents available for restore.
11. Highlight the file you would like to restore - select the save button.
12. Save the file to a location on your Hard drive.
13. Send the users the files.
14. Once the new SharePoint site has been created they can then upload the files back to the site.
Using SharePoint Database Explorer with SQL Server
2. Extract the files to a folder on the desktop.
3. Copy the STS_Servername_1.mdf and the STS_Servername _1_log.ldf to a common location.
4. Open SQL Server Enterprise Manager
a. Start - All Programs - Microsoft SQL Server - SQL Server Enterprise Manager
5. Select Attach Database
7. Browse to the .MDF you need to export files from
9. Select the Database to attach.
11. The database should now be attached.
a. You can check this by viewing the Databases Folder in SQL.
13. Open SharePoint Database Explorer
a. Select File - Set Database Connection.
b. The Database should appear in the drop down list.
15. Select the data base - Leave the permissions set to Windows Authentication - Select OK
16. You will now see a list of Libraries
18. Select the different libraries to view the documents available for restore.
19. Highlight the file you would like to restore - select the save button.
21. Save the file to a location on your Hard drive.
22. Send the users the files.
23. Once the new SharePoint site has been created they can then upload the files back to the site.
PingBack from http://managedsystemservices.co.uk/2007/01/06/recovering-data-from-a-backup-of-a-sharepoint-database/
I found this at the Official SBS blog and while this is not a supported tool, it is an amazing piece