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

2 Answers 2


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.. Commented Sep 24, 2013 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 Commented Sep 24, 2013 at 10:03
  • @RobertLindgren Commented Sep 24, 2013 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 Commented Sep 24, 2013 at 10:27
  • site collection backup is not easiest way to move Commented Sep 24, 2013 at 10:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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