Insufficient disk space in filegroup 'PRIMARY' - SQL Server 2008

Question

Am getting following error:

Msg 1101, Level 17, State 12, Line 1
Could not allocate a new page for database 'CTL' 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 existing files in the filegroup.

Properties of Database are as follows:

File Name               Autogrowth
CTL                     By 10 percent, unrestricted growth
CTL_Indexes             By 1 MB, unrestricted growth

And I got 60 GB of space remaining on the disk.

What would be the issue ?

Are both CTL and CTL_indexes placed on the same disk? Maybe you put it on different disks and there is no place on second disk? — Dalex, May 04 '11 at 06:17
Silly question: are those files in the PRIMARY file group, or another file group? — Jon Seigel, May 08 '11 at 19:32

score 8 · Accepted Answer · answered May 04 '11 at 02:44

8

What edition of SQL server is this for? SQL Express has a 2GB limit on database size that is reported in this way.

answered May 04 '11 at 02:44

Justin

84,773
49
224
367

It is SQL Server 2008 Enterprise Edition – Sreedhar May 04 '11 at 05:19
+1 - I had the same error but was using SS 2005 Express. This helped me out a lot. Was not aware of a limit – JOpuckman Apr 09 '12 at 21:03
For Sql express server 2008 and later the limit is now at 10 GB – T M Jun 30 '22 at 08:54

score 0 · Answer 2 · edited Jan 01 '20 at 01:55

0

I faced similar error and solved it by changing file properties as under:

File Name               Autogrowth
CTL                     By 20 percent, unrestricted growth
CTL_Indexes             By 2 MB, unrestricted growth

Hope this works for you also.

edited Jan 01 '20 at 01:55

tehDorf

775
1
11
32

answered Jun 08 '13 at 13:14

Sushil Pugalia

39
4
14

Insufficient disk space in filegroup 'PRIMARY' - SQL Server 2008

2 Answers2