SQL SERVER 2008 R2 - TEMPDB ERROR

Asked

Viewed 462 times

1

Good morning, by the way, does anyone know a solution to this mistake :

Msg 8921, Level 16, State 1, Line 1 Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.

The way the database is, can make query but when I try to run some process of correction of the database it returns this error, The database has 24gb.

database sql-server sql-server-2008

  • What operation are you trying to perform that generates this error? Add this information to the question to make it clearer.

  • In case the database works with a commercial application and is not accessible due to the error. When I try to repair in sql it returns error preventing fixing.

1 answer

3

In this case you have three things to do:

  1. Check the disk space where tempdb is. Since checkdb uses it to store the verification data temporarily, it probably has no more room to grow. Also check that both tempdb files are set to not have size limitation.

  2. If the above situation is not the cause, you will probably have to do the following:

    • Run this command in the database, it will estimate the space needed to execute the checkdb: Dbcc checkalloc('issuedb') with estimateonly;
    • If the above command still fails, try to restore this database (without giving detach or anything, for God’s sake) on another server, based on a newer backup media. Ai tries to check again.

  3. If nothing of the above solves, try creating another database by copying the data from it, or check with dbcc checktable('table') in each of them to see which one is in trouble.

This message, from the research I’ve done, comes with more information. You can post the complete error message (with subsequent messages), as well as the command executed by you. I also read that this type of error, when it is related to system tables, are hardly recoverable errors, so the wheels the commands, will edit your question with the results.

P.S.: In case it doesn’t come in handy, try using the Migration Wizard SQL Server even to migrate the information to a new database, or use the open-source tool SQL Database Migration Wizard to be able to migrate the data to a new database.

  • I will do the procedure you informed, and return with the information obtained , thanks for the help.

  • I did the procedures you gave me but it really didn’t work , the bank apparently doesn’t have much to do. I don’t know if it is allowed here in the forum but you would have a step by step how I can migrate data from corrupted database to another with error free structure?

  • @Wêklef take a look in that Docs from Microsoft, which explains how to use SQL’s own Wizard. Or uses this tool, that also she makes quickly. I edited the answer with the two solutions.

Browser other questions tagged database sql-server sql-server-2008

You are not signed in. Login or sign up in order to post.