SharePoint database Explorer


 

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 (14)

  1. great software save me a lot of work thanks

  2. zxevil135 says:

    qWPyUC r u crazzy? I told u! I can’t read!

  3. zxevil136 says:

    XK9JDL r u crazzy? I told u! I can’t read!

  4. zxevil134 says:

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

  5. zxevil141 says:

    RrpfwO r u crazzy? I told u! I can’t read!

  6. zxevil150 says:

    xcSQv1 r u crazzy? I told u! I can’t read!

  7. zxevil151 says:

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

  8. zxevil151 says:

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

  9. zxevil152 says:

    oCQgsT r u crazzy? I told u! I can’t read!

  10. zxevil153 says:

    YAE3hP r u crazzy? I told u! I can’t read!

  11. zxevil154 says:

    iMehBX r u crazzy? I told u! I can’t read!

  12. zxevil155 says:

    ptjlm5 r u crazzy? I told u! I can’t read!

  13. Steve says:

    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

  14. Ron says:

    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.