extrobe
1/31/2017 - 2:11 PM

Backing Up SSISDB Log File

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