Restoring SharePoint 2003 Document Library Items from a SQL Backup

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: (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 is a Senior Architect for Insight, based out of Watertown, MA. He has been architecting and developing web based applications his entire career, and has been working with SharePoint for the past 15 years. Geoff is an active member of the SharePoint community, Co-Founder and Co-Organizer of the Boston Area SharePoint Users Group, co-founder for the Boston Office 365 Users Group, co-organizer for SharePoint Saturday Boston and speaks regularly at SharePoint events and user groups.

One Response to Restoring SharePoint 2003 Document Library Items from a SQL Backup

  1. 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.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: