I've noticed that dbcc shrinkdatabase does not shrink the
log file. How do we shrink the log file?

Thanks.

http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Tran Log
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE


--

Andrew J. Kelly
SQL Server MVP


"Dean" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi,

I also had that problem. I used succesfully used this to
shrink my log file to 100 MB.

BACKUP LOG ubb WITH TRUNCATE_ONLY
go
DBCC SHRINKFILE(dataname_log,100)

Good Luck,

Jeroen.