RE: Always on and SSISDB – SQLServerCentral

SSC Guru

Points: 233854

February 28, 2018 at 4:25 am

#1981426

RTaylor2208 - Monday, February 19, 2018 8:53 AM
Turns out using the backup and restore method worked adding the database on the secondary using this method, it would be good though if someone could confirm this is the best way to do this though.
https://blogs.msdn.microsoft.com/mattm/2012/03/23/ssis-catalog-backup-and-restore/

you need to create a credential for the ssidb master key so that it may be read and decrypted on fail over

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉