Thursday 3 July 2014

Compress logs in SQL Server

Compress logs
SELECT name
FROM sys.database_files
WHERE type_desc = 'LOG'
DBCC SHRINKFILE ('DB Name,1)