Today, I was asked to restore deleted files from a deleted Site Collection in our production farm on SharePoint. As usual, when I receive this kind of request (recover deleted files) , the procedure is:
1. Ask SQL Team to restore the DB from the day before deletion
2. Mount the DB in a specific Web Application
3. Set the restored DB as “Offline” in Central Administration
4. Go to the site and export the deleted files to the client’s SharePoint Site
5. Remove the restored DB from the Web Application
6. Delete the DB from SQL
The SQL Corporate rules concerning the backup retention time is 14 days. But this time, the site was deleted for 16 days, so out of the backup retention time. No restore available. I remember that the production DB are keeping the deleted Site Collections for 30 days.
Thus I will be able to restore the deleted Site Collection, and my client will be happy to recover all missing files. Steps to follow are:
Get-SPDeletedSite : this will give the list of all deleted Sites Collection in the Farm
Restore-SPDeletedSite –Identity “/Sites/CD10000059”
/!\ A Site Collection must not already exist at the URL location to perform a restore /!\
Finally, the site is now restored from the DB’s recycle bin.
SharePoint 2010 Hosting Recommendation
HostForLIFE.eu’s SharePoint 2010 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2010 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2010 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2010 plans as well as dedicated SharePoint 2010 Foundation options