Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Filegroup is full

Author  Topic 

eduardofcomelo
Starting Member

3 Posts

Posted - 2006-02-16 : 07:44:40
Hi all!

Please, I have a SQL Server 2000 database, it name is gfg. When I use the insert statement, I receive the error messagem below:

Message : Could not allocate space for object 'tbpolarisAcompanhamento' in database 'gfg' because the 'PRIMARY' filegroup is full.

The ,gfg database, have around 40 megabytes of free space.

somebody knows what would I check to alocate more space to the primary database?

thanks in advanced,

best regards,

Eduardo F. de Melo
------------------
ASP.NET
SQL SERVER, MSDE, MYSQL

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-02-16 : 13:18:43
I would expect autogrow to be turned off completely....

Papillon
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-16 : 13:38:30
quote:
Originally posted by under2811

I would expect autogrow to be turned off completely....

Papillon



Why?

Tara Kizer
aka tduggan
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-16 : 13:39:58
Eduardo, how much free disk space do you have on the drive where the MDF and LDF are located?

Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -