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.

1 Answer 1


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


Restore-SPSite -Identity http://your.DevServer.com -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.

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.