Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Import/export or backup/restore to refresh dev environment?

  Asked By: Jamie    Date: Aug 07    Category: Sharepoint    Views: 2286

We have a dev environment and a prod environment. We want to
periodically refresh the database in the dev environment with a copy of
the prod environment, so that we're testing stuff on relatively recent
data (including configuration). What's the best method for doing that?
What are the merits/pitfalls to using the stsadm import/export command?
What are the merits/pitfalls to using a backup/restore (copy over)



4 Answers Found

Answer #1    Answered By: Deven Gajjar     Answered On: Aug 07

If you want to refresh  your databases do just that. Make backups of your
content DBs in production. Detach your content databases in your dev
environment. Restore your DBs to dev. Reattach them.

If for whatever reason you don't want to do that then backup and restore is your
next best option. It's a lot more work though. The database  option is much

Answer #2    Answered By: Latisha Schneider     Answered On: Aug 07

Will that get both content and configuration  databases?

Answer #3    Answered By: Nora Maxwell     Answered On: Aug 07

It'll do whatever databases you back up and restore. I haven't done this much
with v3, but I don't think you want to bring the Config database  over, just the
Content DBs. In v2 the Config DB had hard coded server names that could really
cause you problems in Dev. The Content DBs have all of your content, so you'll
be fine just bringing them over.

Answer #4    Answered By: Corina Duran     Answered On: Aug 07

Just the content databases.

If you need the SSP databases, that is a whole different world.