Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Refreshing dev with production data

  Asked By: Daniel    Date: Dec 10    Category: Sharepoint    Views: 1487

We're running a mid-size production farm and a
commensurately sized VM dev environment. We need to refresh the dev
environment with production data. Can anyone recommend the best way to
do this? We tried just backing up production DBs and attaching to dev
environment but that didn't work (I don't have the details of exactly
how the DBA did this, so I'd rather just start from scratch with best
practice instructions).



2 Answers Found

Answer #1    Answered By: Deana Lowery     Answered On: Dec 10

I've never had luck detaching db's from prod & copying them to dev/qa &
maintaining full content/functinoality....something always stops working in

The process I use to move prod to dev/qa is to use CA to do a backup of the site
collection & DB to a file share from prod. Then in qa, go into the site
collection & remove the db. Then run a restore from the location where you made
a backup of prod. At the end of the restore, sharepoint should attach to the
db, but most of the time, I have to do it manually.

If you have problems at that point, then it's all about permissions of the
default content access account and the rights it has to the db on the SQL server
(happens most often when your user account doesn't have SA & local administrator
permissions on the SQL server).

This method is more along the lines of a DR type of restore, but it works every

Standard disclaimer applies... your mileage/results will vary since no two
installations are identical.

Answer #2    Answered By: Felecia Goff     Answered On: Dec 10

Another approach is to use stsadm to export and import. This approach will let
you prune file versions and omit security. IIRC, you can also limit the export
to a site or site collection.

Didn't find what you were looking for? Find more on Refreshing dev with production data Or get search suggestion and latest updates.