by zebsadiq
2. February 2011 15:07
Recently I had to investigate why a certain virtual machine’s hard drive had filled up. I discovered that this was caused by a massive SharePoint database that I had imported. The log file for this database was nearly 30gb.
The way to check the log file sizes is by going to: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
Once you’ve determined which database’s log file needs to be shrunk, run the following bit of SQL replacing the database name with your own.
declare @dbname nvarchar(255)
set @dbname = 'REPLACEWITHDATABASENAME'
backup log @dbname with truncate_only DBCC SHRINKDATABASE (@dbname, 0)
After shrinking the log file, the size of the file went down to just 500kb.