Got a large ShareWebDB_log.ldf file?

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

Comments are closed.

Post Navigation