RE: 'PRIMARY' filegroup is full - no it's not!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dale (Dale_at_discussions.microsoft.com)
Date: 02/09/05 

Date: Wed, 9 Feb 2005 09:39:08 -0800

We have having the same exact problem. There is 30+ GB Free on the Drive
 (Dynamic Disk, by the way). Database is set to unrestricted file growth.
 Everything looks fine with the configuration of the sql database...however,
 the database thinks there is no free space on the drive. Very wierd!!
 Database is just shy of 5gb, but General Tab says 0.00Mb Free. Looks like
 ill be calling MS soon!!

 Dale
 txskibum@hotmail.com

"Ray.Net" wrote:

> I have a SQL Server 2000 database, in which the size of the primary
> filegroup is 5 GB. The disk where the data resides has 14 GB of free
> space – that should be more than enough free space for a 5 GB
> database, right?
>
> The problem is that when I perform certain operations (esp. recreating
> a clustered index), it still seems to run out of space with this
> error:
> Could not allocate space for object 'ActivityTracker' in database
> 'DataLoad' because the 'PRIMARY' filegroup is full. The statement has
> been terminated.
>
> Here's where it gets weird: in the database properties "Automatically
> grow file" IS checked, and Maximum file size is unrestricted. So
> there's lots of free space (nearly 3X the size of the db), and the
> growth is not restricted - what makes it think the filegroup is full?
>
> I found a few newsgroup postings that suggested sometimes the
> auto-grow cannot grow fast enough, so you should manually increase the
> size of the database. I tried this, using "alter database" to raise
> the size of the primary filegroup as high as 12GB – more that twice
> its original 5GB size – but it still fails with the error message
> above. And - here's another weird thing – at the time the error
> occurs, the database shrinks itself back down to 5 GB (even though I
> do NOT have the "Auto shrink" property checked). What's going on
> here?
>
> I appreciate any ideas you can offer on why this database seems to run
> out of space when there's plenty of space to be had.
>
> Ray
>

Relevant Pages

  • RE: PRIMARY filegroup is full - no its not!
    ... We have having the same exact problem. ... Database is set to unrestricted file growth. ... > the size of the primary filegroup as high as 12GB –more that twice ...
    (microsoft.public.sqlserver.server)
  • Re: Initial Sync - PDA to SQL Server over Internet
    ... While I didn't have the exact problem you ... problem and perform a PDA sync to my database. ... subsequent replication attempts was telling me that the database already ...
    (microsoft.public.sqlserver.ce)
  • Re: Problem while processing word file with word instance from vb.
    ... tav with database. ... So I do not worry about line or page. ... and when I open doc file normally it shows data in proper way but when ... I am still not sure what you are doing and what the exact problem is. ...
    (microsoft.public.word.vba.beginners)
  • Re: 1412 Error for Hotmail in Entourage???
    ... I am having the same exact problem as many of you... ... I have attributed the problem to Virex -- my free ... received a message telling me I needed to rebuild my database. ...
    (microsoft.public.mac.office.entourage)
  • Re: Can not allocate space for rebuilding index
    ... > I have set the space for the primary filegroup the same ... > size as the size of the whole database. ... > or the size of the log file? ... "Bill Little" wrote in message ...
    (microsoft.public.sqlserver.server)