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.
Cathy_RyanAsked:
Who is Participating?
 
lluddenConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.