Error: 1101, Severity: 17, State: 10

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..
Does anybody know the quick fix to this? Thx.Rose,
Tempdb has filled up its space or has filled the disk
where it was created.
This leads to an MSDN article on expanding databases with
some specific comments on tempdb.
http://tinyurl.com/hoh4
Since tempdb is recreated each time you start the server
a restart will clear the current problem. However, you
should try to find out what was happening that filled
tempdb and try to prevent it from happening again.
Russell Fields
>--Original Message--
>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..
>Does anybody know the quick fix to this? Thx.
>.
>|||Rose,
>> Does anybody know the quick fix to this?
How about the one mentioned in the error message itself? Did you check if
there is enough space in the filegroup?
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Rose Mbatuchic" <simacy6@.yahoo.com> wrote in message
news:0bd401c35059$82aec8b0$a401280a@.phx.gbl...
> 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..
> Does anybody know the quick fix to this? Thx.