Post reply

Could not allocate new page for database 'TEMPDB

  • June 9, 2008 at 4:30 pm

    #122958

    Full message -

    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.)

    Questions is where in SQL 200 can I fix this??????

    The same Query works fine with some amounts of data. With large amounts I get this error

    Thanks

    Greg

  • June 10, 2008 at 6:12 am

    #826572

    May be you can check these two options first:

    1. The TEMPDB might have been configured with some Maximum Size and your transaction needs more than the configured space.

    2. Though Unrestricted growth is set to TEMPDB, the growth % might have been low; so once the limit is reached and the transaction is not completed, it is rolled back.

    Renuka__

    [font="Verdana"]Renuka__[/font]

  • June 10, 2008 at 7:00 am

    #826597

    Thanks. I will check into this and see if I have any luck.

  • June 10, 2008 at 11:05 am

    #826827

    Found the problem. I overlooked the obvious. No disk space!!! After I freed up about 8 GIGs the query works fine. Thanks for the input.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply