question

srivastavanitesh16 avatar image
srivastavanitesh16 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
sql-server-2008sql-server-2005sqlsql-server-2008-r2sql-server-2000
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
perrywhittle avatar image
perrywhittle answered
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
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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
1 Like 1 ·
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.
0 Likes 0 ·
I hope you have some good backups available.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.