Microsoft – SQLServer – Corrupt Database – Database 2 (TempDB)

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

References:

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s