Got a large ShareWebDB_log.ldf file?

On October 1, 2013, in SQL Server, by

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

If you enjoyed this article, please consider sharing it!
Facebook Twitter Delicious Digg

 

Comments are closed.