How to Fix this Issue Permanently in Sql Server

Posted by Jayakumars under Sql Server on 1/13/2017 | Points: 10 | Views : 1038 | Status : [Member] [MVP] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi
How to Fixed this ?

Could not allocate space for object ‘<object_name>’ in database ‘<database_name>’ 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.

I follow this url but issue not fixed . any one guide me proper way

https://blog.sqlauthority.com/2014/03/14/sql-server-error-resolution-could-not-allocate-space-for-object-in-database-because-the-filegroup-is-full/

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: A2H on: 1/13/2017 [Member] [MVP] Silver | Points: 25

0	If you are using SQLServer Express editions then it has size limitations. So even though the size was set to "unlimited", you will still face the exception. Limitation details(Taken from http://www.gfi.com/support/products/gfi-archiver/What-are-the-size-limitations-for-SQL-Express-Databases Microsoft SQL Server 2005 Express edition has a database size limit to 4GB Microsoft SQL Server 2008 Express edition has a database size limit to 4GB Microsoft SQL Server 2008 R2 Express edition has a database size limit to 10GB Microsoft SQL Server 2012 Express edition has a database size limit to 10GB Microsoft SQL Server 2014 Express edition has a database size limit to 10GB Thanks, A2H My Blog Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

If you are using SQLServer Express editions then it has size limitations. So even though the size was set to "unlimited", you will still face the exception.
Limitation details(Taken from http://www.gfi.com/support/products/gfi-archiver/What-are-the-size-limitations-for-SQL-Express-Databases

Microsoft SQL Server 2005 Express edition has a database size limit to 4GB
Microsoft SQL Server 2008 Express edition has a database size limit to 4GB
Microsoft SQL Server 2008 R2 Express edition has a database size limit to 10GB
Microsoft SQL Server 2012 Express edition has a database size limit to 10GB
Microsoft SQL Server 2014 Express edition has a database size limit to 10GB

Thanks,
A2H
My Blog

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 1/19/2017 [Member] [MVP] Platinum | Points: 25

0	https://support.managed.com/kb/a132/error-could-not-allocate-space-object-x-database-your-database-because-primary-filegroup-is-full.aspx Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts