Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

I am getting this error for SQL 2000 "Could not allocate space for object '(SYSTEM table id: -42164838)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full."   How do I get more space

Posted on 2010-11-17
4
452 Views
Last Modified: 2012-05-10
I have googled the error, and I am told I am out of space.  There is no administer here.  I have to do it myself.  How do I go about finding how much space I have, and expanding it.
0
Comment
Question by:Cathy_Ryan
  • 2
4 Comments
 
LVL 18

Accepted Solution

by:
lludden earned 500 total points
ID: 34158725
The drive that the SQL database is on is out of space.  Log onto the SQL server and check the disks.  Free up some space there.
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 34158735
Fastest and easiest is to add another file to the database; put it on a drive that has lots of extra space, and start with a good-sized allocation.  The exact amount will depend on the size of your installation, but 2G should be a decent amount regardless.
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 34158750
Expand "Databases".  Click on "System Databases".

Right-click on "tempdb".  Select "Properties".  Click on "Files" (on the left side of the screen).

Click "Add" (at bottom), and add a new file -- BE SURE THE DRIVE YOU CHOOSE HAS PLENTY OF SPACE.
0
 

Author Closing Comment

by:Cathy_Ryan
ID: 34158966
I have not administrator to add the space.  I was looking for the steps to add the space.  But thank you for your quick response
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question