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
441 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:ScottPletcher
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:ScottPletcher
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Note: You must have administrative privileges in order to create/edit Roles. Salesforce.com (http://www.salesforce.com/) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales and markeā€¦
Read about achieving the basic levels of HRIS security in the workplace.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

707 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now