asked
DBCC Check DB issue Please Help
Dear Sir/Madam, I big follower of your blogs and website I have one issue on my Production DB. Kindly help me Details of the issue are mentioned. Datbase name has been mentioned as IssueDB I have database of 99GB on this database when I am running 1: DBCC Checkdb('IssueDB') --- it gives error as 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 SQL Server Configuration details Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7600: ) 2: Drive on which Tempdb database is located has around 420GB of space left and By 10 percent, unrestricted growth is set for Tempdb database. This server contains two more database we are able to run DBCC checkdb on those databases with no error msg 3: I have also run these command and checked at my level DBCC CHECKALLOC(' IssueDB ') With msg as DBCC results for 'IssueDB'. 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. CHECKALLOC found 0 allocation errors and 0 consistency errors in database 'IssueDB'. DBCC CHECKCATALOG('IssueDB') With msg as DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC CHECKTABLE('dbo.table1')with all_errormsgs,no_infomsgs Command(s) completed successfully. Dbcc Checktable command has been run on all the table by the help of script from url http://www.bpsoftware.com/blog/post/2008/11/25/SQL-DBCC-CHECKTABLE-on-multiple-tables.aspx It run successfully without any error msg 4:I have also tried to run USE [master] GO ALTER DATABASE [IssueDB] SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO DBCC CHECKDB (IssueDB, REPAIR_ALLOW_DATA_LOSS) GO ALTER DATABASE [IssueDB] SET MULTI_USER This gave same error msg as Msg 8921, Level 16, State 1, Line 2 Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors. I have also check all the previous error msg from SQL Server error logs but not able to find anything appropriate I have also run DBCC CHECKDB ('IssueDB') WITH TABLOCK, ALL_ERRORMSGS, NO_INFOMSGS; Same error msg as 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. We are able to take back up and restore the database successfully without any error msg. Database is running on production environment without any problem.Only problem is we are not able to run DBCC CheckDB on this database I have restored this database on different server and followed all the above process but did not succeed to run DBCC CHECKDB. Thanks And Regards Nitesh Srivastava
srivastavanitesh16@gmail.com
Why on earth are you running REPAIR_ALLOW_DATA_LOSS without even understanding what the issue is, my advice is dont. Run Dbcc checkalloc('issuedb') with estimateonly This will indicate the required tempdb space. Please run and post the results of Dbcc checkalloc(''issuedb') with no_infomsgs, all_errormsgs Regards perry
If I were you, I would copy the tables and objects to a new database on a test server and then run dbcc checkdb. Check this first before going any further
Dear Sir, Thanks for the reply I have run both the command and found error,result msg are posted please help. Dbcc checkalloc('issuedb') with estimateonly Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. Dbcc checkalloc('issuedb') with no_infomsgs, all_errormsgs Msg 8921, Level 16, State 1, Line 2 Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
19 People are following this question.
