Why is one of my system drives nearly full?
After a bit of investigating, I find the modellog.ldf file has grown to an outstanding 50Gbs! Stop traffic!
Turns out (Thanks #sqlhelp) the model database was setup for FULL Recovery Model…OUCH!
Okay, simple enough fix! Switch that Recovery Model to Simple, no need for FULL.
Within SSMS, right click the model database (or the db in question), TASK > SHRINK > FILES
In the File Type drop down box, select Log. Ensure the file name is correct, along with the location. Thus far I have chosen release unused space, and simply clicked OK.
Go ahead check the log now…BAM I went from nearly 50Gbs to a few kb – NICE!
Its easy in T-SQL too!
USE [DBMaint2008] GO DBCC SHRINKFILE (N'DBMaint2008_log' , 0, TRUNCATEONLY) GO