SharePoint Database Explorer

 

This tool will help you export files from a corrupt .mdf database.  In order for this to work you must be able to successfully mount the database either through OSQL or SQL.  This tool should be used at your own risk.  Thanks

 

 

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

 

Database Files needed:

1. STS_Servername_1.mdf

2. 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:
  5. At a command prompt type:

osql -S servername\sharepoint –E

1>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'

2>Go

 

  1. Open Database Explorer
  2. Enter the server\instance name
  3. If you copied the database to the MSSQL$SHAREPOINT\data your instance name would be sharepoint
  4. Select the "+" sign
  5. Select the library on the left
  6. It will then show you documents on the right you can export.
  7. Select the different libraries to view the documents available for restore.
  8. Highlight the file you would like to restore - select the save button.
  9. Save the file to a location on your Hard drive.
  10. Send the users the files.
  11. 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

 

Installation

  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 to a common location.
  4. Open SQL Server Enterprise Manager
    1. Start - All Programs - Microsoft SQL Server - SQL Server Enterprise Manager
  5. Select Attach Database
  6. Browse to the .MDF you need to export files from
  7. Select the Database to attach.

The database should now be attached.

  1. You can check this by viewing the Databases Folder in SQL.

 

Open SharePoint Database Explorer

  1. Select File - Set Database Connection.
  2. The Database should appear in the drop down list.
  3. Select the data base  - Leave the permissions set to Windows Authentication -  Select OK
  4. You will now see a list of Libraries
  5. Select the different libraries to view the documents available for restore.
  6. Highlight the file you would like to restore - select the save button.
  7. Save the file to a location on your Hard drive.
  8. Send the users the files.
  9. Once the new SharePoint site has been created they can then upload the files back to the site.

 

Thanks,

>edwalt