Post reply

Log file growth / last entry status = 2

  • November 18, 2005 at 7:26 am

    #110934

    Hello,

    I have a database with a log file that does not reduce in size after  I do a backup. (recovery modell is full)

    I have run these commands

    http://www.broad-lea.com/sql_server/sql_reduce_log_size.html

    and it works fine. But I'm not sure if it is a solution to the problem that the size of the log file will not reduce when I do a backup. As I understand the cause of it is that the last entry in the log file is status 2. But:

    -why is it status 2?

    -what can I do to prevent this?

    I guess a the "normal" situation would be that the last entry in the log file has status = 0, so when you do a backup the log file will reduce in size.

     

    Thanks in advance

     

    //Matte 

  • November 18, 2005 at 7:49 am

    #604634

    backup log just truncates the inactive logs, it does not shrink the log file. So the size of the file is not changed. But the used size should is reduced.

    If your want to reduce the file size, add the DBCC SHRINKFILE command after the log backup.

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

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