Home Forums SQL Server 2017 SQL Server 2017 - Administration Always on and SSISDB RE: Always on and SSISDB

  • February 19, 2018 at 9:45 pm

    #1980380

    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/

    Yep, It was right. 

    The most awaited / expected feature of SQL Server latest versions was the ability to add SSISDB to AG, before 2016 version the failover of the SSISDB database has to be done manually, on which you end up having more work to do.

    In SQL Server 2016 it was introduced with the possibility for automatic failover of SSISDB. ( If you have chosen Always ON for SSISDB as well )

    Please refer below, I think you can get a similar idea of what you've done.

    https://docs.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog

    Apart from these, I'd like to hear from other experts and their views.