Post reply

Disk space

  • April 8, 2011 at 4:49 pm

    #389241

    For disk space on a server, we set up jobs to dba when space 10% or 20% left. So we can know ahead to do something to have more space.

    My question is what will happen if a disk run out of space?

    If it's the drive that stores data or log, is the database going to be crashed?

    And if it's the backup drive, if no space, what will happen, will it only gives error, but you can stil do something?

    Thanks

  • April 8, 2011 at 7:55 pm

    #1309500

    annasql (4/8/2011)

    For disk space on a server, we set up jobs to dba when space 10% or 20% left. So we can know ahead to do something to have more space.

    Phew! Ideally that margin is much bigger (what do folks think? I think 35% free is a ceiling).

    My question is what will happen if a disk run out of space?

    If it's the drive that stores data or log, is the database going to be crashed?

    I wouldn't want to find out the hard way.

  • April 9, 2011 at 3:31 am

    #1309527

    My question is what will happen if a disk run out of space?

    If it's the drive that stores data or log, is the database going to be crashed?

    Hi

    Simply, if there is no proper sapace log/data file get currupted. Data base will becone out of operation.

    Ali
    MCTS SQL Server2k8

  • April 9, 2011 at 12:01 pm

    #1309563

    We do monitor 30% too.

    So inow I know if space is run out on database data, log drive, database will crash.

    How about backup drive?

    Thanks

  • April 9, 2011 at 1:05 pm

    #1309567

    If the disk somehow fills up completely and the SQL Server is not able to allocate more space, an error 1101 or 1105 will be raised (and logged). The database will continue to remain online, but data can no longer be inserted.

    You can read all about it at the following MSN link: http://msdn.microsoft.com/en-us/library/ms366198.aspx

    If however, your transaction log runs of space, error #9002 is raised. You can read about troubleshooting it here: http://msdn.microsoft.com/en-us/library/ms175495.aspx

    Hope it helps.

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins

Viewing 5 posts - 1 through 4 (of 4 total)

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