Advertisements

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

 

Advertisements

About Geoff Varosky
Geoff Varosky is a Senior Architect for BlueMetal Architects, 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 13 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.

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: