Loading...

Setting Up Disaster Recovery Failover to a Warm Standby Workflow Engine Environment

You can set up a disaster recovery failover to a warm standby Workflow Engine environment. A disaster recovery failover to a warm standby Workflow Engine environment minimizes the downtime that business-critical workflows experience if your production host becomes unavailable.

Before You Begin

The production server must be able to communicate with the standby server either using a local area network (LAN) within the same domain, a different domain, or across a Wide Area Network (WAN).

About This Task

  • If you install the Workflow Engine on your CommServe computer, you do not need to install the SQL Server Agent because the Workflow Engine (WFEngine) database is automatically included in the disaster recovery backup for the CommServe database. If the Workflow Engine is installed on a computer other than the CommServe computer, you must configure a Microsoft SQL Server Agent to back up the Workflow Engine (WFEngine) database.
  • Set the frequency of the daily backup and restore schedules to meet your business needs. A two minute frequency is used in the following instructions.

Production Host

  1. Install the Workflow Engine.
  2. Install the SQL Server Agent:
  3. Add the Workflow Engine (WFEngine) database to a SQL Server Agent subclient.

    For instructions, see Manually Discovering SQL Databases.

  4. Run a full backup of the Workflow Engine (WFEngine) database.

    For instructions, see Backing Up SQL Databases.

  5. For the Workflow Engine (WFEngine) database transaction logs, schedule a daily backup that runs every two minutes.

    For instructions, see Backing Up SQL Transaction Logs.

  6. Optional: Schedule and then disable a restore job for future use:
    1. For the Workflow Engine (WFEngine) database transaction logs, schedule a one time restore.

      Important: On the Options tab, select the Latest Backup Data check box and the Apply Log Backups Only check box.

      For instructions, see Restoring SQL Transaction Logs to a Hot Standby Server.

    2. Disable the one time restore schedule.

      For instructions, see Enabling or Disabling a Schedule.

Standby Host

  1. Install the Workflow Engine.

    Note:  If the standby host has a Workflow Engine installed on one Commvault instance, a second Commvault instance can be installed for the standby Workflow Engine. For instructions on setting up additional instances of the Workflow Engine, see Setting Up Multiple Instances of the Workflow Engine.

  2. Install the SQL Server Agent:
  3. On the instance where the Workflow Engine is installed, stop the Workflow service.

    For information about the Workflow service, see Available Services.

  4. Add the Workflow Engine (WFEngine) database to a SQL Server Agent subclient.

    For instructions, see Manually Discovering SQL Databases.

  5. For the Workflow Engine (WFEngine) database transaction logs, schedule a daily restore that runs every two minutes.

    Important: On the Options tab, select the Latest Backup Data check box and the Apply Log Backups Only check box.

    For instructions, see Restoring SQL Transaction Logs to a Hot Standby Server.

  6. Optional: Schedule and then disable a backup job for future use:
    1. For the Workflow Engine (WFEngine) database transaction logs, schedule a daily backup.

      For instructions, see Backing Up SQL Transaction Logs.

    2. Disable the daily backup schedule.

      For instructions, see Enabling or Disabling a Schedule.

Related Topics

Restoring Workflow Transaction Logs to a Standby Host

Last modified: 12/1/2020 10:00:13 PM