Forum Discussion
HLi2023
Aug 22, 2023Copper Contributor
Increase file size in sql server
Hello, I am new for sql server . I got insufficient disk space for PRIMARY filegroup. Is it ok I modify file size for 4 files in the filegroup? thanks HLi
Aug 27, 2023
A reason could be running out of disk space but also the database autogrowth settings could be configured as NONE so if there is free space you will get that error
See this link to understand how to change this setting as well as best practices
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/considerations-autogrow-autoshrink
See this link to understand how to change this setting as well as best practices
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/considerations-autogrow-autoshrink
HLi2023
Aug 28, 2023Copper Contributor
Thank you Javier. Previous dba set auto grow is none and I was told not to change it . I checked with OS admin we have enough physical disk space.
I am trying to do is change database file property initial size from 250 mb to 300 mb manually. Is it ok or should I try to rebuild some clustered indexes? Thanks.
I am trying to do is change database file property initial size from 250 mb to 300 mb manually. Is it ok or should I try to rebuild some clustered indexes? Thanks.
- Aug 28, 2023
Hi HLi2023
glad you found the root cause. As for which value you should set the value the answer is depends .basically you do not want to set it small because having the db growing constantly is not a good practice because expanding the file will cause IO operations that not ideal in the middle of the business day. And too big could eventually fill up the disk if you are running with low disk space. You have to monitor the data grow rate and decide (you can set a value now and adjust it after monitoring )
hope it helps
regards
Javier
Please mark the question as Answered so others can benefit too
- olafhelperAug 28, 2023Bronze Contributor300 MB is nowadays really small and you worry about disk space?
Change the database size to 1 GB or more.