I have an existing SharePoint 2010 site. I am going to start doing some development but want to take a copy of live onto dev so I can develop against that. Is there a way I can do it. If I could automate it that would be great. So i can do the same in the future as production gets out of sync.

2 Answers 2


Do you physically have a development environment and a production environment, or are they just separate web applications?

In environments where you have two separate environments I usually use the content database to copy production back to dev. Ask your admin/DBA to copy the content database from production to dev, and add that content DB to the environment.

You can also take the approach of making a site backup or export using STSADM or PowerShell and restoring it to the other URL in dev.

  • Different environments. Does the content DB contain all the permissions?
    – Randy
    Commented May 16, 2011 at 21:35
  • Yes, your content database will bring over a mirror of the site collection(s) inside that content database... permissions, content, objects, etc. The only pieces that won't come with it are features or anything that's deployed to the 14 hive. You'll want to install those first. Each web app has one or more content databases, so if you're looking at bringing over a specific site collection you'll have to move that to its own content DB first (via PowerShell). When you add the content database to the farm you'll specify the web application that it will be put on.
    – webdes03
    Commented May 16, 2011 at 23:44

You should backup the content database from production and restore it on your dev server.

Backup content database

Restore content database

Note: You'll need a web application to restore the content database to. Here are the simple steps if you're using SQL Server to do the backup/restore:

  1. Backup the content database using SQL Server Management Studio
  2. Restore the database on your dev SQL Server using SQL Server Management Studio
  3. Create a new web application on your dev server
  4. Remove its content database
  5. Add the content database into the newly created web application using stsadm addcontentdb or Powershell Mount-SPContentDatabase

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.