We have an intranet that comprises of a single site collection and i want to restore a sql backup of this site collection to our staging environment so i can do some development against a couple of existing list.

im really not sure how to do this Can anyone give me some advice on the best way and what the potential problems will be


In short, Mount-SPContentDatabase powershell command should help

PS: If there are any custom solutions, you will need to deploy all WSPs otherwise you might get errors.. Plus if you want to use existing accounts you may need to Migrate user accounts using Move-SPUser


you can also take backup of your site collection and restore to your new server.

  • That's exactly what he says in his question.. Sep 24 '13 at 9:49
  • Richard Banks asking for only SQL backup but i suggest him to take backup of whole site collection using STSADM so everything in his site collection remain same with data Sep 24 '13 at 10:03
  • @RobertLindgren Sep 24 '13 at 10:27
  • It was not me who downvoted you, so I guess I was not alone in thinking that your answer did not contribute Sep 24 '13 at 10:27
  • site collection backup is not easiest way to move Sep 24 '13 at 10:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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