This article applies to the following products:
- Messageware EPG 2019
- Messageware EPG 2016
- Messageware EPG 2013
OVERVIEW
The Always On availability groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring.
You can find out more about the High Availability from the following Microsoft Article:
EPG can also be made to work with High Availability, the following steps will ensure EPG full functionality in the High Availability set up.
SOLUTION
The EPG database would need to be reinstalled with the High availability option checked and the EPG cleanup jobs would need to be deployed to the Secondary server in the High Availability group.
- Install EPG Database on the PRIMARY SQL
- Open the DB installer
- Checkmark the “High Availability” Option
- Fill in the details and click connect
- Once it is connected, click create database
- Add the EPG Database to the Availability Databases
- Right Click on the Database > Tasks > Back Up
- Under Availability Database > Right Click > Add Database
- Deploy the EPG Cleanup jobs on the SECONDARY SQL
- Open the Db install High Availability Job
- Checkmark the “High Availability” Option
- Fill in the details and click connect
- Once it is connected, click Deploy Jobs
Once the database setup has been completed, you can now proceed with the EPG installation.
For this installation, the database HAS to be in High Availability.
- Stop and disable the World Wide Web Publishing Service (W3SVC)
- Install EPG CAS component first
- In the installation > In in the Server Name > Put in the SQL High Availability Listener Name.
- Fill the other details and connect > click continue and install
- Once installed, you can start the World Wide Web Publishing Service Again
- Next Install the EPG Web Management with the same steps and during the installation out in the SQL High Availability Listener Name.
- Finally install EPG monitor