January 15, 2004 at 5:11 pm
I am running a TSQL script with multiple statements (~1600 lines). It runs for 42 minutes and then aborts with the following message:
Could not allocate space for object '(SYSTEM table id: -936712632)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full.
What does this mean and how can I fix the problem?
Any help is much appreciated.
January 16, 2004 at 1:36 am
It means that tempdb (or the disk it is on) has filled up.
January 16, 2004 at 9:46 am
on your tempdb check if unlimited autogrow is enabled.
If yes check if you have enough free space on the drive which holds your tempdb
Bye
Gabor
January 16, 2004 at 10:10 am
Thank you Gabor. The disk with tempdb is out of space. The settings for tempdb is on auto grow with unrestricted max. I'll need to work on the space issue.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply