edwalt's - Things I Wish I'd known about SBS 2003.... Blogs - edwalt's - Things I Wish I'd known about SBS 2003.... - Site Home - TechNet Blogs

Blogs

SharePoint database Explorer

  • Comments 14
  • Likes
 

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

 

 

Comments
  • great software save me a lot of work thanks

  • qWPyUC r u crazzy? I told u! I can't read!

  • XK9JDL r u crazzy? I told u! I can't read!

  • dRMZGB r u crazzy? I told u! I can't read, man!

  • RrpfwO r u crazzy? I told u! I can't read!

  • xcSQv1 r u crazzy? I told u! I can't read!

  • 3WNNkt r u crazzy? I told u! I can't read!

  • 3WNNkt r u crazzy? I told u! I can't read!

  • oCQgsT r u crazzy? I told u! I can't read!

  • YAE3hP r u crazzy? I told u! I can't read!

  • iMehBX r u crazzy? I told u! I can't read!

  • ptjlm5 r u crazzy? I told u! I can't read!

  • I am trying to access data via SQL server.  The databses have been attached, but do not show up in the select drop down list in DBExplore, just a number of listings for "master" which fail to connect.  What do I need to do to access the attached DBs in SQL?  Thanks

  • I noticed that if you have subfolders and a list and multiple files with the same name in different subfolders within the list, then the software only lists one file with that name and you do not knwo which subfolder it belows to.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment