Question

2
Replies
76
Views
Close popover
Anand Subramaniam (AnandS0631)
Government of Canada
Anand Subramaniam
Government of Canada
CA
AnandS0631 Member since 2018 1 post
Government of Canada
Posted: April 16, 2019
Last activity: May 1, 2019
Closed

High Availablity setup with SQL Server 2012 or 2016

Hi All,

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.

Thanks

Anand

Data Integration
Moderation Team has archived post