Insufficient disk space in filegroup
A few days before one of my DBA friend suggested to write a blog on database file growth issues and how to troubleshoot it. I liked his suggestion as we DBAs often face space issues in production. In this blog, we will see what steps and precautions we can take if a database file growth issue is encountered. To reproduce the issue below steps have been followed. 1) Created database “Growth” . 2) Added one filegroup named “Growth” and make it default. 3) Added one NDF named “Growth2.ndf” in the filegroup “Growth” and kept it on another drive. 4) Created Table named “employee_details” in filegroup “Growth” 5) Inserted data into the table and created multiple indexes with low fill factor till the datafile is not getting full. Once the data file got full and there is no space available for new data, then the below error got triggered. The statement has been terminated. Msg 1101, Level 17, State 12, Line 10 Could not allocate a new page for database 'Growth' ...