TEMPDB error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

TEMPDB error

Author

Topic

greg.wollman
Starting Member

5 Posts

Posted - 2008-06-09 : 18:20:51

Have a customer of mine on on SQL 2000 and getting the following error when running a query -

Error: -2147217900, (Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth.)

Any feedback would help

Thanks!!!!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-09 : 18:47:37

Expand the tempdb data file.

This is for 2005, but perhaps you can get some ideas for 2000: http://weblogs.sqlteam.com/tarad/archive/2008/05/20/60604.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

greg.wollman
Starting Member

5 Posts

Posted - 2008-06-10 : 13:10:58

Found the problem. I overlooked the obvious. No disk space!!!!! Thanks for the feedback.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources