Post reply

How to reduce log file size ?

  • August 1, 2002 at 7:54 am

    #78999

    can any one tell me how to reduce log file size?

    I tried 'Truncate Database' & 'Shrink Database' options but it doesn't affect too much on my log file.

    Software Programmer


    Software Programmer

  • August 1, 2002 at 8:02 am

    #433804

    If your DB & Logs are being backed up, then after the TLog has been backed up, this should free up space in your log file and leave only the active portion of the log.

    Once this is done use

    DBCC SHRINKFILE ('<DBName>_Log', <New Size>)

    IE...

    DBCC SHRINKFILE ('Pubs_Log', 10)

    Would shrink the log file to 10MB

    Clive Strong

    clivestrong@btinternet.com

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

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