Recover Sharepoint file

Bellscape
Bellscape used Ask the Experts™
on
Hi - SBS 2011 box with Sharepoint setup.  A user has deleted an excel document that was accessed via sharepoint - is there anyway to recover this file.

We Use Acronis to backup images nightly so if the sharepoint files are stored somewhere hopefully I can access it and restore it.

Is this possible
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010

Commented:
Hello,

check the recycling bin of the site. If it's not there, have the site collection admin check the site collection recycling bin.

If it's not there you will need to resort to the backup, but that's beyond my expertise.

cheers, teylyn

Author

Commented:
It is not in the recycle bin of the drive.  I believe the file was removed from someone who had accessed it via a mapped drive on their PC.
QPR

Commented:
So this document was accessed via Excel Services and wasn't just an xls in a doc library?
You may need to look to your file system backups rather than SP
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
Any ideas where to look in the file system backup - where is sharepoint data stored?
QPR

Commented:
All sharepoint data is stored in content databases BUT if this is an excel file that is being used via excel services then it is a different story.

So was it a document uploaded to a document library or was it a document that was part of excel services?

Author

Commented:
I dont really know - It was used as a calendar.  Below is the address I was given.  I know nothing about sharepoint sorry

http://companyweb/p/Plan/BOOKING%20CALENDAR.xls
QPR

Commented:
ok im going to guess that it's in a document library then...
teylyn suggested you check the recycle bin but it sounds like you checked the windows recycle bin.
Sharepoint has it's own recycle bin(s).
Navigate to the site where the xls was hosted and down the left hand side you should see a link to "recycle bin" click it and check in there.

If the link is not there then click "site actions" and then view all site content. At the very end of the page is a link to the recycle bin.

If not there then you (or someone with permissions) need to navigate to http://companyweb and then again "site actions" - "site settings" - "site collection administration" and then "recycle bin"

So long as this wasn't a long time ago and the recycle bin settings are at default then it should be there.

Failing all of the above then it's restore content DB time which will overwrite any changes or additions since the last backup so you/they can choose if this is desireable.

But long before getting into the SQL side of things I would find out how the user deleted the file in the first place. Normally there is no concept of mapped drives when dealing with sharepoint documents.

PS I am only repeating what teylyn already suggested so points to them should this turn out to be the solution please.

Author

Commented:
Thanks,

I checked the recycle bin on the site(it is empty).  The user who deleted the file has a mapped drive to the sharepoint data and deleted(overwrote) the file in question direct from there.
Most Valuable Expert 2011
Awarded 2010

Commented:
I wasn't talking about the recycle bin of the drive. SharePoint keeps its own recycle bins on each site. Depending on how the document was deleted, it may be there. If it was deleted via the SharePoint user interface, then it should be there for 30 days, after that it will be in the recycle bin of the site collection.

If the user deleted the document via Windows Explorer or similar, then it won't be in the SharePoint recycle bin.

Do you create regular backups of your SharePoint content databases? These will need to be restored and the document can be recovered by a SQL dba who mounts the restored database.

cheers, teylyn

Author

Commented:
Thanks Teylyn,

Yeah I checked the site and it is not in the recycle bin - it was deleted/overwritten via Windows Explorer.  I was hoping that this data was stored in a folder, not a database somewehere and I could restore it from my backups(disk images)
Overwrite is not the same as deleting. If you overwrite the document, you will not find it in the recycle bin!  The only option is to restore the SQL Content DB to a different SharePoint Farm and 'exporting/downloading' the file and restore it to you're production environment!
File could be recovered via document history(version control)
QPR

Commented:
Not sure I understand, if you had versioning turned on in the document library then the "deleted" document would have just been a version of the document. If the document was deleted/overwritten how did you access it in order to restore a previous version?

Author

Commented:
Solution

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial