• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • Last Modified:

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

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
Cathy_Ryan
Asked:
Cathy_Ryan
  • 2
1 Solution
 
lluddenCommented:
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
 
Scott PletcherSenior DBACommented:
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
 
Scott PletcherSenior DBACommented:
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
 
Cathy_RyanAuthor Commented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now