Two Things I Would Change in SSISDB Setup

• mtassin

  SSC-Insane

  Points: 23099

  More actions

  January 11, 2019 at 6:57 am

  #2018687

  No they haven't... at least not as of SQL 2016

  ---

  
  --Mark Tassin
  MCITP - SQL Server DBA
  Proud member of the Anti-RBAR alliance.
  For help with Performance click this link[/url]
  For tips on how to post your problems[/url]

• gbritton1

  SSCertifiable

  Points: 6522

  More actions

  January 11, 2019 at 12:55 pm

  #2018723

  bkubicek - Monday, March 28, 2016 9:57 PM

  Comments posted to this topic are about the item Two Things I Would Change in SSISDB Setup

  At least with SQL Server 2016 you can now put SSISDB in an AG. SQL Server 2016 HA Series Part 2 – SSIS and Availability Groups.  That's important for us since with 2012 we had to deploy changes individually to all replicas.  OTOH if you do that, you have to leave RECOVERY = FULL.