MIP Ideas Portal

Support SQL Server AlwaysOn High Availability

Currently, MIP puts the database in single user mode during year end closing rather than coding to insure all users are out of the system and not allowing logins until closing is completed.  This means that if your MIP database is in a SQL Server AlwaysOn High Availability Availability Group, you must break your AG and remove the database prior to closing.  Then after closing is completed you must then reconfigure you MIP database in the AG group.

My financial database is one the two databases I am require to always have online.  Having to break my AG group causes me to breach this requirement.

This technology has existed since MS SQL Server 2012, so it is not new technology.

  • Guest
  • May 17 2019
  • Attach files