• Daario (3/29/2016)


    This is another thing you may want to do upon setup:

    ALTER DATABASE [SSISDB] SET RECOVERY SIMPLE;

    The transaction log can get a bit unruly, and Point-in-time recovery has limited usefulness in this database.

    --

    Winter is coming

    Good point



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]