Shrinkfile SqlServer2008R2

Exemplo:

ALTER DATABASE WR_TF2 
SET RECOVERY SIMPLE;  
GO  
-- Shrink the truncated log file to 1 MB.  
DBCC SHRINKFILE (WR_TF2_log, 1) ;  
GO  
-- Reset the database recovery model.  
ALTER DATABASE WR_TF2
SET RECOVERY FULL;  
GO