Post reply

Error 1101

  • May 12, 2003 at 12:51 am

    #59127

    Hi,

    How can I get rid of this error:

    Executed as user: Administrator. 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. [SQLSTATE 42000] (Error 1101). The step failed.

    Please reply me soon.

    Thanks in advance.

    Anbu

  • May 12, 2003 at 1:55 pm

    #456888

    Seems like, for the current situation, there is not enough disk space as the error indicated. Reboot should clean out / recreate TempDB. Assign another filegroup to TEMPDB on a drive with available space. What is the TempDB size versus total number of DBs and what is the size of each.

  • May 12, 2003 at 1:57 pm

    #456889

    Sorry, obviously autogrow for TempDB must be switched on.

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

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