Government of Canada
Last activity: 1 May 2019 16:23 EDT
High Availablity setup with SQL Server 2012 or 2016
We have a setup with SQL Server 2012, have 2 databases Primary and secondary connected thru cluster. Pega JVM always connects thru cluster. We tried manually taking the primary offline and made the secondary db as primary this process took less than a minute but within this short period of time all JVM's went down the existing pega connections are not ported over to the other database.
Have any one used SQL Server in HA setup if so please share your experience and solution.