Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

One of the Site collection Administrators has deleted the Site Collection mistakenly, so we want to restore it back. What would the best approach ?

Some of the SQL stuff:

  • SQL Full backup -> Every day SQL
  • Incremental backup -> Every hour

We have not implemented any SharePoint disaster recovery methods.

share|improve this question
    
My favorite third party tool for this: metalogix.com/Products/… restores right from content database after you restore the db. Disclaimer: I'm not affiliated with Metalogix, but regularly use their stuff. Otherwise the designated answer is the best practice. –  tekiegreg Apr 4 '13 at 14:39
add comment

1 Answer

up vote 3 down vote accepted
  1. Restore the SQL DB containing the site collection
  2. Create new web application (any host name or port will do)
  3. Attach Content Database using

    stsadm -o addcontentdb -url http://URLofWindowsSharePointServicesSite -databasename DatabaseName -databaseserver DatabaseServer

  4. You should be able to find your site collection in the web application

  5. Using stsadm -o export -url [site-coll-new-url] -includeusersecurity -versions 4 export the full web application
  6. Using stsadm -o import -url [site-coll-dest-url] -versions 2 import the site collection to your old web app.

Please verify the stsadm -o export and stsadm -o import syntax exactly. I'm writing this off the top of my head.

OR you can try using Appasure DocRetriever

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.