• SQLKnowItAll (3/22/2013)


    Our SE team takes snapshots/images of the server itself for this purpose. Although, we store our SSIS packages in MSDB, so those are protected by MSDB backups.

    I would be careful about recovering SSIS packages from MSDB. If that system crashed and you build a new system that is not the exact same version you could have problems.

    Besides, there are several source control systems available where you really should be managing these kinds of objects. SSIS packages are basically code - so a code repository would be the best solution, in my opinion.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs