Cacher is the code snippet organizer for pro developers

--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);