SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 dbcc check errors
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

albertkohl
Aged Yak Warrior

USA
740 Posts

Posted - 10/23/2010 :  15:15:29  Show Profile  Visit albertkohl's Homepage  Reply with Quote
i ran a dbcc check on a database and got the below errors... now what?!

DBCC results for 'NMOL_SESSION'.
Msg 8928, Level 16, State 1, Line 1
Object ID 197575742, index ID 2, partition ID 72057594039304192, alloc unit ID 72057594040942592 (type In-row data): Page (1:7128) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 197575742, index ID 2, partition ID 72057594039304192, alloc unit ID 72057594040942592 (type In-row data), page (1:7128). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29493257 and -4.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 197575742, index ID 2, partition ID 72057594039304192, alloc unit ID 72057594040942592 (type In-row data). Page (1:7128) was not seen in the scan although its parent (1:18739) and previous (1:19255) refer to it. Check any previous errors.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 197575742, index ID 2, partition ID 72057594039304192, alloc unit ID 72057594040942592 (type In-row data). Page (1:19256) is missing a reference from previous page (1:7128). Possible chain linkage problem.
There are 422642 rows in 8374 pages for object "NMOL_SESSION".
CHECKDB found 0 allocation errors and 4 consistency errors in table 'NMOL_SESSION' (object ID 197575742).

Edited by - tkizer on 10/23/2010 15:25:42

tkizer
Almighty SQL Goddess

USA
37287 Posts

Posted - 10/23/2010 :  15:26:21  Show Profile  Visit tkizer's Homepage  Reply with Quote
I edited your post to remove the code tags (made the post much too wide) and changed the forum to Data Corruption Issues. Code tags are only needed to retain formatting, which isn't needed for your output.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

albertkohl
Aged Yak Warrior

USA
740 Posts

Posted - 10/23/2010 :  15:27:42  Show Profile  Visit albertkohl's Homepage  Reply with Quote
thanks tara, sorry for the nubbish mistake.
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 10/23/2010 :  17:10:12  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Please run the following and post the full and complete output. There's at least one line missing from your post.


DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS


Do you have a clean backup? That's a backup that doesn't have the corruption in it.

--
Gail Shaw
SQL Server MVP

Edited by - GilaMonster on 10/23/2010 17:10:52
Go to Top of Page

albertkohl
Aged Yak Warrior

USA
740 Posts

Posted - 10/25/2010 :  03:24:32  Show Profile  Visit albertkohl's Homepage  Reply with Quote
honestly, i'm not sure, i dont run the dbcc check often enough to know... the table that's showing the errors is kinda expendable so if i loss data it's not a huge deal.

are there any recommendations you guys whould have to run checks like this so often, in the event of an error, notifiy me?

thanks!


Msg 8928, Level 16, State 1, Line 1
Object ID 197575742, index ID 2, partition ID 72057594039304192, alloc unit ID 72057594040942592 (type In-row data): Page (1:7128) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 197575742, index ID 2, partition ID 72057594039304192, alloc unit ID 72057594040942592 (type In-row data), page (1:7128). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29493257 and -4.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 197575742, index ID 2, partition ID 72057594039304192, alloc unit ID 72057594040942592 (type In-row data). Page (1:7128) was not seen in the scan although its parent (1:18739) and previous (1:19255) refer to it. Check any previous errors.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 197575742, index ID 2, partition ID 72057594039304192, alloc unit ID 72057594040942592 (type In-row data). Page (1:19256) is missing a reference from previous page (1:7128). Possible chain linkage problem.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'NMOL_SESSION' (object ID 197575742).
CHECKDB found 0 allocation errors and 4 consistency errors in database 'Website'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Website).
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 10/25/2010 :  05:01:15  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Despite the recommendations, I do not suggest repair with allow data loss. It should not be necessary in this case, unless there's something I've missed.

Run the following to identify the index in question, drop that index and then recreate it (not rebuild or create with drop_existing)

select object_name(object_id) as TableName, name as IndexName 
from sys.indexes 
where object_id = 197575742 and index_id = 2


Once you've done that, please run that checkDB command again and see what it returns.

As for regular checkDBs, absolutely essential. How often depends on your backup retention strategy. You should do checkDB often enough that restoring from backup is always an option. Set up a job or a maint plan an d have it alert you on failure.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

albertkohl
Aged Yak Warrior

USA
740 Posts

Posted - 10/25/2010 :  15:42:45  Show Profile  Visit albertkohl's Homepage  Reply with Quote
worked perfectly, thanks!

i guess i'll start running dbcc checks prior to my full backups, seems like a good place to start... appreciate the help!
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 10/25/2010 :  16:46:51  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Glad to hear it.

Before backups is what I like to recommend. Isn't always possible, but is good place to start.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000