• Then you should be set. That column value indicates that the log space is not been reused because a log backup is required. Once the log backup runs (check and make sure that they are actually running successfully), the space in the log should be reused.

    You can shrink the file down to a reasonable size (say 1GB) and see how things go from there.

    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