0

I've got a VB.Net program that updates an SQL Server 2008R2 database.

The disk is using 86.2Gb of 126Gb so there's lots of free space.

enter image description here

The autogrowth is set, as you can see, but I get the following error message on various threads:

Could not allocate space for object 'sys.syscolpars'.'nc' in database 'MyDB' 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 MDF file is currently 9Gb in size.

If Autogrowth is set, and there'e sufficient disk space, why is this happening?

EDIT:

OK, further testing has provided the following...

The SQL server in this case is not 2008R2 as suspected, but 2014 SQLExpress... sorry for the bum steer on that; I got my servers mixed up...

When I try this on a 2008R2 set up exactly the same, it seems to work ok without producing the error message.

So, the question seems to be is SQLexpress limited in size?

Tym
  • 89
  • 2
  • 14
  • 1
    Possible duplicate of ["Primary Filegroup is Full" in SQL Server 2008 Standard for no apparent reason](https://stackoverflow.com/questions/1951647/primary-filegroup-is-full-in-sql-server-2008-standard-for-no-apparent-reason) – Ken White Jun 15 '17 at 18:07
  • I defragged the drive, deleted the database and re-created it from scratch so that doesn't seem applicable. – Tym Jun 15 '17 at 19:55
  • 1
    There is more than one answer to that question. Please don't focus only on accepted answers; they tend to indicate only what was most helpful to that particular user at that point in time. There are also several other questions here that contain the same (or a very similar) error message that offer other possible solutions. Your first effort should be to search here and via Google for existing information before posting here. – Ken White Jun 15 '17 at 20:21
  • 1
    https://dba.stackexchange.com/q/33700 – Ken White Jun 15 '17 at 20:24

1 Answers1

1

The maximum size for the MDF file on SQL Express 2014 is currently 10GB so I imagine its trying to grow above that.

If you review the Cross-Box Scale Limits section (Maximum relational database size) with Features Supported by the Editions of SQL Server 2014 you will see why.

kevchadders
  • 8,335
  • 4
  • 42
  • 61