Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002

    Lightbulb Unanswered: 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.

  2. #2
    Join Date
    Aug 2002

    execute following statment;
    use tempdb

    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.


  3. #3
    Join Date
    Oct 2002

    DB solution

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

    Best regards.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts