Best Practices for moving database

Discussion created by Mitch_Denis_38 on Jul 11, 2014

What does your company use a Best Practices for moving Automation Engine databases?

Thought I'd bring this up as we in Support don't do this that often, but more and more are receiving questions on this.  TheAutomic documentation covers this to a certain extent, but it's more for changing the database from one type to another and not so much for just moving the database from one server to another - something which many companies do on a fairly regular basis.

From our point of view, you'd want to follow the steps:

  1. Stop your WPs and CPs
  2. Copy/Move the database
  3. Update your database client connections to be sure they point to the new server
  4. Start your WPs and CPs with a COLD start (always a best practice when your database goes down)

For those of you who have done this before and specifically those of you who do this often, are there any steps missing?  Are there any snags you've run into?  When answering, please specify the version of AE you are on as well as the type and version of database.