Automic Workload Automation

Best Practices for moving database

  • 1.  Best Practices for moving database

    Posted 07-11-2014 12:40 PM

    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.