Howto: Fix an oversized modellog.ldf
modellog.ldf too big? First try to figure out what’s using the log file: use [model] select (sum(size) * (8192/1024)) / 1024 from dbo.sysfiles WHERE (status & 0x40) 0 DBCC SQLPERF(LOGSPACE) select ceiling((sum(size) * (8192.0)) / 1024.0) from dbo.sysfiles exec sp_spaceused…