Disk Space issue

  • Hi all,

    I'm getting disk space error: drive has only 6 MB space.

    I have checked the drive, the drive has only ldf of particular db and size of that file is 194gb

    i'm going to shrink that file

    any suggestions?

  • I cheked everything .

    1) no active transactions

    2) log_reuse_wait=log backup

    we have a dialy backup at 10 pm

  • How often are you running log backups?

    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
  • no log backups: only full backups

  • subbkarth (7/18/2011)


    no log backups: only full backups

    We know. We get that answer question 100 times a month. Which is why Gail wrote an amazing article on the topic which you should read ASAP.

  • subbkarth (7/18/2011)


    no log backups: only full backups

    Given that, and that the log reuse wait is 'Log Backup', what does it tell you?

    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

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

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