Post reply

Shrinking log file, best practice?

  • June 12, 2012 at 7:29 am

    #262836

    Hi,

    I'm not a DBA but I'm in charge of a SQL 2000 database, so it's why I need advices from experts.

    I have a 5 gig data file and a 25 gig log file. The database is backed up every day. When I do a Shrink log file, no space is freed and the file still grow. If I restrict the log file grow and limit its size, no more transactions are done in the database and a error is fired saying the log file is full.

    The database is in production and in extensive use all day long.

    So, what should I do to shrink the log file?

    thanks a lot for your help and advices

    Dominic

  • June 12, 2012 at 7:41 am

    #1499797

    Please read through this - Managing Transaction Logs[/url]

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 12, 2012 at 8:34 am

    #1499827

    thanks for the really helpfull link

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

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