Post reply

log files

  • September 16, 2008 at 2:15 am

    #124576

    Hi, Suggestions required, space in a drive is increasing rapidly, the log files are configured to the L drive. The auto shrink option is disabled for these databases, will this be an issue?

    What are suggestions to gain space?

    thanks

  • September 16, 2008 at 2:30 am

    #872183

    Get more drives.

    Can you explain a bit more? What drives are filling up (and with what) and where are things configured?

    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

  • September 16, 2008 at 2:33 am

    #872185

    the drive is L drive and this is fillingup with the log files.

    The Auto shrink option is set to False for all the databases. There is only one primary file group.

    let me know if any further info is required.

    thanks

  • September 16, 2008 at 2:39 am

    #872186

    Does your backup / restore plan include log backups?

  • September 16, 2008 at 2:45 am

    #872188

    yes there are log backups for the databases to the L drive, they are all kept for 1 day, ie retention period is 1 day

  • September 16, 2008 at 2:52 am

    #872195

    See http://sqlskills.com/blogs/kimberly/2005/06/25/8StepsToBetterTransactionLogThroughput.aspx

    Step 8 may help you...check the log file fragmentation.

  • September 16, 2008 at 3:00 am

    #872201

    What's filling up the drive? The log files themselves (.ldf) or the log backups?

    What else is on the drive?

    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

  • September 16, 2008 at 3:12 am

    #872208

    its the log transactional logs that are fillingup, .ldf in the drive, other than that, there are transactional log backups, which are dated todays, as the retention period is 1 day old.

  • September 16, 2008 at 3:27 am

    #872212

    Can you keep the backups elsewhere?

  • September 16, 2008 at 3:35 am

    #872215

    Do you know why the transaction log is growing? If you have regular log backups, it should not be continually growing.

    Query the sys.databases view and see what the log_reuse_wait_desc column says for that particular database. There will be a reason that the space in the log fine is not been reused

    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

  • September 16, 2008 at 4:18 am

    #872232

    You can find additional advice here:

    http://support.microsoft.com/kb/873235

Viewing 11 posts - 1 through 10 (of 10 total)

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