Primary filegroup is full - SQL Server Forums

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 2005 Forums

SQL Server Administration (2005)

Primary filegroup is full

Author

Topic

carumuga
Posting Yak Master

174 Posts

Posted - 2009-11-09 : 02:57:53

Hi,

I get this error on running the insert command in the database.

Could not allocate space for object 'Employee' in database
'EmpDB' because the 'PRIMARY' filegroup is full.

Please help.

Thanks.

carumuga
Posting Yak Master

174 Posts

Posted - 2009-11-09 : 03:05:45

Additional info. abt the database. It has around 700 mb free space and its set to Unrestricted file growth and automatically grow file by 100mb.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-09 : 10:44:29

checked free disk space?

carumuga
Posting Yak Master

174 Posts

Posted - 2009-11-09 : 11:25:12

How to check the free disk space?
Thanks.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-11-09 : 11:39:47

right click on your database (in SSMS) - properties - files
There you can see the mapping from filegroup PRIMARY to hard disk.
Check that hard disk fro free disk space.

No, you're never too old to Yak'n'Roll if you're too young to die.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-11-09 : 11:44:53

Or in query window run:

use your_database
go
sp_helpfile

There you can see filegroup and mapped hard disk (filename)

No, you're never too old to Yak'n'Roll if you're too young to die.

carumuga
Posting Yak Master

174 Posts

Posted - 2009-11-12 : 02:36:13

I have enough space in the drive now... Is it because of the space constraint in the drive or some other issue that hampers the job from running?

krishnarajeesh
Yak Posting Veteran

67 Posts