Microsoft – SQLServer – Corrupt Database – Database 2 (TempDB)
Could not find an entry for table or index with partition ID 441134024294400 in database 2. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored procedure, or execute DBCC CHECKDB.
This error implicitly references TempDB:
If you issue select db_name(2) referencing the database id (2) mentioned, you will get tempdb.
As one cannot place tempDB in single-user mode and run corrective procedure (DBCC CheckDB) against it, simple look towards your next Maintenance Window if you have one and restart MS SQL Server Instance;
In case where you ‘re a 24-hour shop …. one of my old Director’s said (once the company went public) to allow my leg to slip underneath me a bit and hope the box reboots and comes back up.
Credit goes to ConsultDB – http://blog.consultdba.com/2010/05/dbcc-checkdb-and-tempdb.html
- DBCC CheckDB
- DBC CheckDB and TempDB