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