Sharepoint (WSS 3.0) Restore Question

Domo · 22 Jun 2010 at 09:42

We have a corrupt Excel file in one of our document libraries which we need to restore. Is it possible to restore that one file from a full farm backup without restoring the entire farm?

PoD · 22 Jun 2010 at 12:22

You need to use the SQL backup to restore files

Dangerous · 22 Jun 2010 at 12:28

Not as far as I am aware of so its a full restore to a test system and then export the corrupted file to the live system.

Domo · 22 Jun 2010 at 12:53

Same response I got on TechNet forums - just didn't want to believe it! Thanks.

Dangerous · 22 Jun 2010 at 13:37

Domo said:
Same response I got on TechNet forums - just didn't want to believe it! Thanks.

lol so you come to OcUK?

ringo747 · 28 Jun 2010 at 15:26

Doing things like this will be much easier in SharePoint 2010. You can browse offline content databases and export the content - very handy.

SiriusB · 28 Jun 2010 at 15:37

Might have to convince a client to upgrade! They are always breaking stuff lol.

ringo747 · 28 Jun 2010 at 15:39

There are so many reasons why an upgrade to SP2010 is worthwhile but if they aren't running x64 hardware already it could turn out pretty expensive.

PoD · 28 Jun 2010 at 15:58

ringo747 said:
Doing things like this will be much easier in SharePoint 2010. You can browse offline content databases and export the content - very handy.

These tools are available for 2007.

I will make a note to find them tomorrow

SiriusB · 28 Jun 2010 at 16:01

It is all 64 bit

They are also accountants, so it would take some special kind of miracle to convince them they want to spend money to fix their problem!

SiriusB · 28 Jun 2010 at 16:01

PoD said:
These tools are available for 2007.

I will make a note to find them tomorrow

Please do! Will save me a headache.

ringo747 · 28 Jun 2010 at 16:03

Probably something available on codeplex that does this for 2007 but not something I have used.

Domo · 28 Jun 2010 at 22:54

PoD said:
These tools are available for 2007.

I will make a note to find them tomorrow

You're right - there's a whole bunch of stuff by Quest, in fact I've just downloaded a trial version of their recovery software. A desktop client which can query a .bak file and restore individual objects.

We've also purchased Control Point by Axceler - much better central admin than that provided in MOSS + granular controls when migrating sites from one farm to another. An additional view £k but hopefully worth the investment.