sqlguru
SSC-Addicted
Points: 471
More actions
May 31, 2023 at 10:48 pm
#4201832
I was thinking to add SSIS db to Always on AG group. So during failover does anything need to be done differently in order to work packages?
Ant-Green
SSC Guru
Points: 113498
June 1, 2023 at 7:42 am
#4202057
SQL 2012/2014 yes, you need a job to sort out the encryption keys on failover.
https://sqlrider.net/2021/05/automating-alwayson-availability-group-failover-for-ssisdb-2012-2014/
2016 onwards, once you have added the SSISDB to the AOAG ensure you enable the Always On Support, so that it automatically creates these encryption key jobs for you.
https://www.sqlshack.com/configure-integration-services-catalog-database-ssisdb-in-sql-server-always-on-availability-groups/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply