Sunday, February 19, 2012

Could not allocate new page for database TEMPDB.

I tried to create a new table in VIEW to accomplish some urgent work and I have received the following message:

Server: Msg 1101, Level 17, State 10, Line 1
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.

It should be recognized that the MS SQL Server performance is slower than before. What files the TEMPDB contains, which need to be cleared from time to time, and how can I solve this above mentioned matter.
Thank you.Hi,

execute following statment;
use tempdb
go
sp_helpfile

If growth is set to 0 (Zero), your tempdb can't allocate more space. See books online to read how to change growth and how to allocate.

/Mada|||Thank you !!
I will try to use it and I will search for books online to have the solution.

Best regards.

No comments:

Post a Comment