I tried to add a row to a table. That time the “Structure less material operation error: Could not allocate space for object. Because the ‘PRIMARY’ filegroup is full.” Error occurred and row is not added.
I tried below solutions:
- Increase autogrowth size and set maximum size to unlimited.
- Check on Filegroups -> primary- Autogrowth All Files check box check on.
- Set maximum size to -1 by executing a query.
- Compression
- Restart SQL server by applying this solutions and also restart system.
I have space in my disc.
But these solutions are not worked.
Sometimes the row added, but sometimes issue occurred.
Is there is any other solution for this issue?
I have to add rows. In my database there is space, because when try to add through sql management studio, the row is added.
SHABLA M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.