Got a large ShareWebDB_log.ldf file? – IT Crumbs

My ShareWebDB_log file was huge on my SBS 2008 server.

So I fired up the SQL 2005 management express (run as admin)

Choose the ShareWebDB

Clicked on new query and did this:

USE ShareWebDb
GO
DBCC SHRINKFILE(ShareWebDb_log, 1)
BACKUP LOG ShareWebDb WITH TRUNCATE_ONLY
DBCC SHRINKFILE(ShareWebDb_log, 1)
GO

Now that file is much smaller