How To Add SSISDB To Availability Group | MS SQL SERVER 2019

Опубликовано: 04 Октябрь 2024
на канале: MS SQL DBA Tech Support
1,205
15

Note:Please do remember SSIS services has to be installed in all secondary replicas.
Please try to maintain service master key and database master key same in all Nodes as best practise to avoid issues further.
Please Makesure SMK is not used for other encrypting certificates and other in secondary replicas.