Post reply

SQL 7 Trans log too big. How shrinK

  • March 4, 2003 at 8:25 am

    #450225

    I have found that DBCC SHRINKFILE does not always work.

    I have had to do the following and then use DBCC SHRINKGILE to free up space:

    backup log <database_name>

    with no_log

    Jeremy Kemp

  • March 13, 2003 at 2:43 am

    #450956

    I also had a strange encounter with this problem. After empting the logfile with the backup with no-log option, i was able to shrink the file in sql2000 with the DBCC shrinkfile command, but this didn't work on a WinNT SQL7 machine. Here i solved the problem by using enterprise manager / all tasks/ Truncate Log ( an option not availble in the 2000 version). To my surprise, the log was shrunk, not truncated! Perhaps they misnamed the option?

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply