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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-20 : 09:45:27
|
| denise writes "We are seeing the following messages:Error: 1101, Severity 17, State 10. 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. TEMPDB is set to autogrow and there is space available.I appreciate any help on the best way to handle this. Thanks very much." |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2006-04-21 : 14:41:37
|
quote:
Originally posted by AskSQLTeam
denise writes "We are seeing the following messages:Error: 1101, Severity 17, State 10. 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. TEMPDB is set to autogrow and there is space available.I appreciate any help on the best way to handle this. Thanks very much."
The error means you have run out of disk space or your tempdb is out of space.Daniel, MCP, A+SQL Server DBAwww.dallasteam.com |
 |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-04-21 : 15:05:13
|
| As it is Friday and you are out of space, I'd say it's a good time to start the weekend early. If you aren't familiar with how to check the TEMPDB filesize and correct the problem just let us know in a different question since you can't respond to this one. |
|
|
|
|
|
|
error 1101