Backing Up SSISDB Log File
--Check the current Size DBCC SQLPERF(LOGSPACE) --Backup the dile BACKUP LOG SSISDB TO DISK = 'C:\xFer2\ssisdb_log_20161128.trn' WITH INIT; GO --Shrink the DB DBCC SHRINKFILE (N'log' , target_size=0);