January 20, 2015 at 7:49 am
Has anyone setup SSISDB 2014 with the Always-On feature. If so, could you provide some step-by-step documentation.
January 20, 2015 at 10:01 am
Could you be a little more specific? Are you having issues setting it up? The functionality should work the same as any other database in the Availability Group.
January 21, 2015 at 12:47 am
Have seen it but not done it. There is a script you need to put on your jobs to make sure they execute on the right node and to re-encrypt the master key after failover.
Also once you've done this you can't apply service packs until you remove it from the group and add it back at the end.
Best resource here: http://blogs.msdn.com/b/mattm/archive/2012/09/19/ssis-with-alwayson.aspx
January 21, 2015 at 7:52 am
Thank you! really appreciate it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply