SharePoint 2010 recover document

If someone overrights a document, is there an easy way to recover the old document or is just going thru the sql database the easiest way?
Jack_son_Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jessc7Commented:
Have you checked the User and Site Collection Recycle Bins? Or has the document been deleted there as well?
0
Jack_son_Author Commented:
i didnt see it there. i think he overwrote the document.

I can pull from backup but it does take longer.
0
jessc7Commented:
Another potential easy answer - was versioning turned on?
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

jessc7Commented:
I know this is for 2007, but it appears that it might not be possible without resorting to the DB backup:

http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/78175a66-9598-4c28-9b0e-938ab376da97/

Maybe someone else has an idea.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jack_son_Author Commented:
yes unfortunately versioning is off
0
Jack_son_Author Commented:
would versioning help with this situation in the future?
0
jessc7Commented:
Yes, when overwriting a file in a library with versioning turned on, SharePoint will just create another version. In this scenario, you would have been able to recover a previous version as the newest version, and been fine.
0
Jack_son_Author Commented:
ok, thanks;  as for common practices,  is enabling this for all sites common / best practice?  It would have definitely saved me a lot of time in this case
0
jessc7Commented:
I don't believe it is enabled by default, as it can increase storage space in SQL dramatically on a large deployment. However, if you understand that each version of a document takes up storage space, you can plan adequately. If you enable versioning, it makes sense to limit the number of versions allowed within the corresponding library. I have used 3 - 5 versions as a rule of thumb, unless requirements dictate otherwise.

In the past I have created versioning where it was needed to have a historical view, or that I had experienced a similar scenario as you, where certain high priority content had been overwritten. If it was low priority content, it would be given a low SLA of recovery (DB recovery or other methods if possible), or maybe not an SLA at all (no recovery, only recreate).
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.