Restoring SharePoint 2003 Document Library Items from a SQL Backup
March 10, 2009 1 Comment
I get asked this question almost weekly – “Is there any way to restore files from a SharePoint 2003 document library from a SQL backup?”
So – I thought I would make a post about it. Indeed there is – released by James Edelen several years ago – available from here: http://www.mindsharpblogs.com/james/archive/2005/01/20/189.aspx (I also have copies in my Live Drive – links below, in case these ever go away, as they have in the past).
There are two utilities here, SharePoint Database Explorer and SPExport. SharePoint Database Explorer will allow you explore a SharePoint farm hierarchy directly from the SQL database, and SPExport will allow you to export documents from a document library from a SQL database directly, to a locally accessible resource (computer, network fileshare, etc.)
Local copies of the utilities:
SPExport Binaries
SPExport Source
SharePoint Database Explorer Binaries
SharePoint Database Explorer Source
About Geoff Varosky
Geoff Varosky's Blog 
I need that SPExport thingy I think, could you add a new link? I tried the Sharepoint Database explorer from codeplex (latest version, safe link) but could only browse a tree of directories and no files where visible.