SQL SERVER 2008 r2 - TEMPDB ERROR

0

Good morning, does anyone know a solution to this error:

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 bank is, it manages to make a query but when I try to run some bank correction process it returns this error, The bank has 24gb.

    
asked by anonymous 08.09.2017 / 13:17

1 answer

2

In this case there are three things to do:

  • Check the disk space where tempdb is. Because checkdb uses the same to hold the verification data temporarily, it probably has no more room to grow. Also check that the two tempdb files are set up to have no size limitation.

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

    • Execute this command in the database, it will estimate the space required to execute 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. Then try checking again.
  • If none of the above resolves, try creating another database by copying its data, or check with dbcc checktable ('table') on each one to see which one is in trouble.

    / li>

    This message, by the searches I've done, is accompanied by more information. You can post the complete error message (with subsequent messages), as well as the command that you execute. I also read that this type of error, when it is related to system tables, are errors that are difficult to recover, so to the wheels the commands will edit your question with the results.

    PS: If you do not get it right, try using Migration Wizard to even migrate the information to a new database, or use the SQL Database open-source tool Migration Wizard to migrate the data to a new database.

        
  • 08.09.2017 / 13:42