You have two servers named Served and Server2. Both servers have SQL Server 2012
installed. Both servers have a SQL Server Integration Services (SSIS) catalog.
You are preparing a disaster recovery plan for a business intelligence (BI) solution.
You need to ensure that the SSIS catalog from Server1 can be restored to Server2.
Which two actions should you perform on Server1? Each correct answer presents part of the
solution.
A.
Back up the master database.
B.
Run sp.configure ‘clr enabled’, 0.
C.
Back up the master key of the SSISDB database.
D.
Back up the master key of the master database.
E.
Back up the SSISDB database.
F.
Run sp_configure ‘clr enabled’, 1.
https://blogs.msdn.microsoft.com/mattm/2012/03/23/ssis-catalog-backup-and-restore/