http://blogs.msdn.com/b/mattm/archive/2012/03/23/ssis-catalog-backup-and-restore.aspxIntegration Services catalog (SSISDB) uses the encryption mechanism available in SQL Server to protect its sensitive data. So backup and restore of SSIS catalog across machines need some extra steps in addition to the usual backup and restore steps. Thisen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/mattm/archive/2012/03/23/ssis-catalog-backup-and-restore.aspx#10291929Mon, 09 Apr 2012 16:12:49 GMT91d46819-8472-40ad-a661-2c78acb4018c:10291929ArthurZ<p>Turned out there is no backup for either. What to do next?</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10291929" width="1" height="1">http://blogs.msdn.com/b/mattm/archive/2012/03/23/ssis-catalog-backup-and-restore.aspx#10291352Fri, 06 Apr 2012 02:36:03 GMT91d46819-8472-40ad-a661-2c78acb4018c:10291352Kaarthik Sivashanmugam<p>For restore operation, you do not need the password used when creating the catalog. Backup of the master key and the password used to protect it should be enough.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10291352" width="1" height="1">http://blogs.msdn.com/b/mattm/archive/2012/03/23/ssis-catalog-backup-and-restore.aspx#10287753Mon, 26 Mar 2012 20:53:32 GMT91d46819-8472-40ad-a661-2c78acb4018c:10287753ArthurZ<p>The password used to encrypt the catalog with (at its creation time), if not available anymore (e.g. employee left) what are the implications of not having this password? </p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10287753" width="1" height="1">