Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Unhappy Unanswered: SQL Server message 1101

    I am new to SQL Admin .
    A scheduled JOB runs nightly to update a database with the days info.
    This has been running fine for a very long time.
    The JOB consists of many stored procedures but now the last one is failing with following message:
    SQL Server message 1101, state 1, severity 17: unable to allocate new
    page for database 'tempdb'. There are no more pages available on valid
    allocation pages.

    space can be created by dropping objects, extending the database or
    dumping the log with no_log.
    I tried to Shrink TEMPDB but get the following error:

    Server: Msg 8909, Level 16, State 1, Line 1
    Table error: Object ID 0, index ID 0, page ID (1:192). The PageId in the page header = (0:0).

    Restarting SQL server has not helped.

  2. #2
    Join Date
    Nov 2002
    What do you have tempdb allocated to?

    Go to tempdb and click properties and look at the Datafiles tab

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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