log file

Question

hi I use a sql server 2000. My log file size is too larger around 9gb .how can i squeeze it . thankx faraz

Mahesh Chand · Answer

Try using SHRINKFILE. USE DatabaseName GO DBCC SHRINKFILE ( TransactionLogName > 1 ) BACKUP LOG DatabaseName > WITH TRUNCATE_ONLY DBCC SHRINKFILE ( TransactionLogName > 1 ) Also here is some reading on shirinking a log file: http://bloggingabout.net/blogs/mglaser/archive/2007/01/12/sql-server-tip-shrinking-a-sql-server-log.aspx