Share via

SharePoint database Explorer

  • Article

 

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: https://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

  • Anonymous
    September 08, 2006
    great software save me a lot of work thanks

  • Anonymous
    February 29, 2008
    qWPyUC r u crazzy? I told u! I can't read!

  • Anonymous
    March 01, 2008
    XK9JDL r u crazzy? I told u! I can't read!

  • Anonymous
    March 06, 2008
    dRMZGB r u crazzy? I told u! I can't read, man!

  • Anonymous
    March 06, 2008
    RrpfwO r u crazzy? I told u! I can't read!

  • Anonymous
    March 07, 2008
    xcSQv1 r u crazzy? I told u! I can't read!

  • Anonymous
    March 07, 2008
    3WNNkt r u crazzy? I told u! I can't read!

  • Anonymous
    March 07, 2008
    3WNNkt r u crazzy? I told u! I can't read!

  • Anonymous
    March 07, 2008
    oCQgsT r u crazzy? I told u! I can't read!

  • Anonymous
    March 07, 2008
    YAE3hP r u crazzy? I told u! I can't read!

  • Anonymous
    March 08, 2008
    iMehBX r u crazzy? I told u! I can't read!

  • Anonymous
    March 08, 2008
    ptjlm5 r u crazzy? I told u! I can't read!

  • Anonymous
    March 10, 2008
    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

  • Anonymous
    April 11, 2010
    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.