I got the following error while creating orders in the database:
Could not allocate space for object 'pfm.IndividualContact'.'PK_IndividualContact' in database 'SelectDb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
The database does have autogrow set with a maximum size of unlimited. How do I fix this?
Database filegroup full error
Moderator: Phil Barton
-
- Posts: 1377
- Joined: Wed Jan 15, 2014 3:50 pm
- Location: Raleigh, NC
- Contact:
Re: Database filegroup full error
Sorry I do not have an answer. I have passed the question to R&D. I'll pass back any response.
Bob Richards, Senior Software Developer, SoftPro
-
- Posts: 1377
- Joined: Wed Jan 15, 2014 3:50 pm
- Location: Raleigh, NC
- Contact:
Re: Database filegroup full error
R&D has responded with potential fixes.
If you have autogrowth turned on and set to unlimited growth - you may have filled the up the disk. Or possibly if the database is getting large, it could need a large chunk of space on the disk for the next expansion of the database.
Here are some options.
If you have autogrowth turned on and set to unlimited growth - you may have filled the up the disk. Or possibly if the database is getting large, it could need a large chunk of space on the disk for the next expansion of the database.
Here are some options.
- Easiest would be to clean up space on the drive where the DB is currently at (assuming that is what is wrong).
- Move the DB to a new drive (preferably dedicated to SQL).
Bob Richards, Senior Software Developer, SoftPro
-
- Posts: 68
- Joined: Tue Mar 03, 2020 5:23 pm
Re: Database filegroup full error
Hi Bob, There is 1.13 TB of free space on the disk and it is defragmented every night. Any other ideas?
-
- Posts: 1377
- Joined: Wed Jan 15, 2014 3:50 pm
- Location: Raleigh, NC
- Contact:
Re: Database filegroup full error
Sorry but I do not. I can generally help with Select but not SQL. Not sure what is going on with your SQL instance.
The only thing I can think of is it possible to uninstall Select and blow away the databases then re-install Select? That should get development back going again and may be your only choice if Google lets you down.
Good luck.![Smile :)](./images/smilies/icon_e_smile.gif)
The only thing I can think of is it possible to uninstall Select and blow away the databases then re-install Select? That should get development back going again and may be your only choice if Google lets you down.
Good luck.
![Smile :)](./images/smilies/icon_e_smile.gif)
Bob Richards, Senior Software Developer, SoftPro