Home Forums SQL Server 2008 SQL Server 2008 Administration How would you recover from shutdown due to lack of drive space RE: How would you recover from shutdown due to lack of drive space

  • March 27, 2013 at 4:23 pm

    #1601414

    Elizabeth.Block (3/27/2013)

    I had heard eons ago that SQL Server would shut itself down if it ran out of disk space. Is this an urban myth?

    It shouldn't do. There's probably some set of circumstances where it can, but it would be more than just tempDB and a user database log running out of space. TempDB runs out of space, current queries using it will be rolled back, user database log runs out of space, data modifications fail and roll back and database goes read only.

    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