SSISDB – the SSIS Catalog database

There is a new system database in town! The SSISDB catalog holds all of the essential server metadata for SSIS projects that have been deployed to the SSIS server. This includes the package operational history, parameters, environments and the deployment history. The SSISDB database resides on the relational database engine and can be treated like any other database in terms of backup and maintenance, including full, differential and transaction log backups. It stores both the SSIS project and the project deployment .ispac file—an XML format file, which represents the metadata describing the SSIS project. More information can be found at http://msdn.microsoft.com/en-us/library/ff952821(v=sql.105).aspx.

Note

If you wish to backup and restore SSISDB to another server, you need to follow a few steps in addition to the obvious ones. This article available on the MSDN site details how to deal with backing up and restoring the master key to allow you to restore...