SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two different servers with Sharepoint 2010 standard edition setup. I have two different SQL database servers(DEV_Content and PROD_Content) for these two environments. I would like to create webapplication backup from production and restore it in development server. So that two server looks similar with same site collections and content database as in Prod Server. I copied webapplication backup from Prod. Server without any problem. But when I try to restore webapplication to development, instead of Development SQL server, it shows Production server. Does this mean , if I restore my backup files. it will overwrite to Prod server (which I dont want)? Here is the image:enter image description here

Here in this image, all the default setup are the setups from my Prodcution server.

share|improve this question

Hopefully this helps you out...
I perform all of my backups and restores using Powershell.


Restore-SPSite -Identity -Path C:\Backups\your-backup-name.bak -Force

Perform this script on the Dev server and you will always know that you are restoring the data to the correct server.

share|improve this answer

Your Answer


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.