Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 426
  • Last Modified:

SQL SERVER OUT OF SPACE

Can someone tell me if it is possible to crash a sql 2008 database if the drive array hosting the database becomes overly full...Literally out of space. Is it also possible to damage the back-up if this happens. I am looking for diffrent scenarios.

Thanks !!
0
PAULADAMSJR
Asked:
PAULADAMSJR
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Application can crash saying there is no more space for storage.It wont corrucpt any data.
0
 
Tony303Commented:
I wonder even if a backup would be able to happen in a full disk situation.
It should fail in my opinion, even if the drive where the backup is located has space.

The mere fact of starting a backup, or trying to, will increase tempdb, msdb, so if those files are on the already full drive then I think it will fail.
0
 
PAULADAMSJRAuthor Commented:
Could it also in some way cause the backup to become unusable ?

Thanks !!
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Tony303Commented:
I suppose, if the drive full problem came whilst a backup was in progress then that backup would be unusable. But I think you would see the backup report a failure. So you'd have to use your previous "good" backup.

Do you have a problem trying to restore a backup?
0
 
Chris LuttrellSenior Database ArchitectCommented:
yes if any of the files for your system databases, be it data files or transaction log files, fail to extend because of lack of space, the SQL server will shut down with an error.  As previously stated, if you are trying to create a backup at the time of failure the backup would fail and be unusable.  However, SQL server will not let you start a backup if there is not space on the drive for the size of the database you are running the backup on so the backup itself is usually not the problem.  But I guess if there is just barely enough space and something else grabs space out from under the backup before it can finish it could be the cause of the failure, but that would be a fringe case.
0
 
PAULADAMSJRAuthor Commented:
The system was on a virtual. Once I increased the VXD drive size, not only did did SQL fire back up automatically after a re-boot, the back-up was able to successfully complete. We did have to revert back to a previous back-up because the backup that was in progress during the failure actually became corrupt.


Thank you to everyone for your value input. Thank you to CGLuttrell for heading me down the correct path to resolve.

PA~
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now