DavidOverton.com
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  
Recovering files from sharepoint databases without all the hassle - or ever wondered where the files were in the SQL database anyway

I found this at the Official SBS blog and while this is not a supported tool, it is an amazing piece of information to have.

A quick snippet from the article states:

[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:

  • A customer has overwritten an important document in SharePoint and no local copy is available; document versioning has not been enabled for the library.  The customer does not want to force users to log off the server during normal business hours.  In this case, you would simply restore the database files from backup, mount them, and retrieve the documents.
  • During disaster recovery, if no backups other than the database files exist, we may manually extract the files from the database as a "belt and suspenders" approach to disaster recovery.  This is also useful if there are any concerns about ACLs moving documents to a server in a new domain.  This method is not recommended for extensive disaster recovery procedures where a large number of document libraries must be exported, but we've found it to be sufficient for many SBS deployments.
  • A critical change has been made to a document, and the author(s) is not sure of the date the document should be restored back to.  Again, no versioning is in place.  Multiple copies of the document must be recovered for comparison.  It's easier to restore 3 databases and extract the document than it is to restore, mount, and extend 3 SharePoint sites.

One to save for a rainy day!!

ttfn

David


Posted Fri, Jan 12 2007 1:04 AM by David Overton

Comments

Paul wrote re: Recovering files from sharepoint databases without all the hassle - or ever wondered where the files were in the SQL database anyway
on Wed, Dec 1 2010 10:08 PM

Spent the last hour looking at this (and getting the tool as the link on the page to get the explorer tool is wrong) and it just plain doesn't work for SBS 2008. Error in the the Sharepoint Database Explorer tool is "Invalid column name 'Content'"

David Overton wrote re: Recovering files from sharepoint databases without all the hassle - or ever wondered where the files were in the SQL database anyway
on Sun, Dec 5 2010 10:00 PM

Paul,

Just looked at this and from the date, this is about SBS 2008 and more importantly, WSS v2.  SBS 2008 ships with WSS v3.

I'm sorry that this tripped you up.

David

Add a Comment

(required)
(optional)
(required)
Remember Me?

(c)David Overton 2006-23