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)
 Space for TempDB

Author  Topic 

ereader
Yak Posting Veteran

50 Posts

Posted - 2003-07-26 : 04:24:38
hi all,

I am firing an query on the productin server but it's giving me the error related to the tempdb
------------------------------------------------------------------
Microsoft OLE DB Provider for SQL Server (0x80040E14)
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.
-------------------------------------------------------------------

i have checked the file growth for the data file and the transaction log of the database it by default auto incremented file growth

chadmat
The Chadinator

1974 Posts

Posted - 2003-07-27 : 16:34:09
Is the tempdb drive almost out of disk space?

-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.
Go to Top of Page
   

- Advertisement -