Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Primary filegroup full but plenty of disk space

Author  Topic 

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2011-02-21 : 10:21:05
Hi I'm getting the below error saying the primary filegroup is full. However there is 281GB free on this drive. Has anyone experienced this before? And do you know what the solution is?

Could not allocate a new page for database 'Database_name' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for exist.

Sachin.Nand

2937 Posts

Posted - 2011-02-21 : 11:56:46
The error itself has a solution.Set the autogrowth option for the filegroup.It seems you have set a fixed size for it.

PBUH

Go to Top of Page
   

- Advertisement -