locked
Backing up the Sql 2014 SSISDB Catalog RRS feed

  • Question

  • We created a SSISDB catalog (appears under Integration Services Catalog in SSMS). We also noted a DB called SSISDB was created at the same time as the catalog. I assume that backing up that DB, in effect, backs up the SSIDB catalog. Is that correct? 

    TIA,

    edm2

    P.S. If so, I'll backup that DB, delete the actual catalog, and see if I can restore the catalog from the backup.

    Tuesday, February 9, 2016 4:07 PM

Answers

  • Hi edm2,

    Yes, by backing up this DB you can restore all the SSIS packages deployed to the catalog.


    Arthur

    MyBlog


    Twitter

    • Marked as answer by edm2 Tuesday, February 9, 2016 7:02 PM
    Tuesday, February 9, 2016 4:39 PM