Forum Discussion
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
- The error message is Could not allocate a new page for database x because of insufficient disk space in filegroup ‘primary’
- 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- 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.- 300 MB is nowadays really small and you worry about disk space?
Change the database size to 1 GB or more.
