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