March 30, 2017 at 10:00 am
Hi,
Hoping someone can help in my understanding of a recent issue with one of our databases.
The datafile for the database is sitting at around 1TB in size. SSMS shrinkfile screen tells us that around 500GB of this is "available free space".
The issue we had was that the file attempted to autogrow, which failed due to a disk space issue, when I would have expected the "available free space" to be used first? Am i wrong in thinking that is what should have happened before there being any need to autogrow?
Thanks in advance for any help!
Cheers.
March 30, 2017 at 10:02 am
depends on what was happening, if the file attempts to autogrow and fails the action will rollback leaving what looks to be sufficient free space. Something obviouslt tried to use 500GB+ of space and rolled back i would say
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 3, 2017 at 6:03 am
Hi,
Please check the Autogrow settings on DB file and change it to some definite number of MBs instead of percentage increase. Looks like in your case 10 % of growth is so huge and requires lots of free disk sapce which is not available, hence it is failing while autogrowing.
Regards,
Ankur
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply