Post reply

LDF file growth

  • February 2, 2011 at 12:30 am

    #144972

    Hi,

    one of our production server X- database --- LDF file is growing

    SIZE MAXSIZE GROWTH

    X_DataX.MDFPRIMARY119936 KB Unlimited25%data only

    x_LogX.LDF NULL 21763456 KBUnlimited25%log only

    Total DB size is now : 21370.50 MB

    AS PER MY KNOWLEDGE SHINKING DB IN PRODUCTION IS NOT RECOMMAMNDED

    Please provide the solution to reduce the LDF file size

  • February 2, 2011 at 12:54 am

    #1281263

    First, you need to find out what is causing the log file to grow. You could start with some simple steps like running sp_who2 etc and find out details about processes running in the db. Based on that you could go forward. Check for open transacations etc.

    M&M

  • February 2, 2011 at 1:16 am

    #1281270

    Let me guess, full recovery model, no log backups?

    Please read through this: http://www.sqlservercentral.com/articles/64582/

    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

  • February 2, 2011 at 10:45 pm

    #1281721

    Thanks Gail,

    it is in full Recovery only

    i took full backup then i scheduled Trn backup now it is reduced

    Thanks in advance

  • February 3, 2011 at 3:07 am

    #1281780

    Great, now make sure that you're running those tran log backups regularly.

    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

  • February 3, 2011 at 3:47 am

    #1281792

    Take T-Log back ups regularly, It helps

  • February 4, 2011 at 3:05 pm

    #1282734

    Boy, if I had a nickel for every one of these types of posts - or every time I have seen a CLIENT do this . . . :w00t:

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 7 posts - 1 through 6 (of 6 total)

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