checkdb- final authority on if db is corrupt?

if checkDB dbcc does not give any errors on a db, does it confirm that there is no data corruption concern? or could there be still situations where CHECKDB may not catch a corruption issue?
LVL 5
25112Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
CheckDB will search for data corruption and that includes referential integrity.
What kind of corruption are you trying to find?
0
25112Author Commented:
the db on one 2005 server is corrupt. I ran CHECKDB and below are some of the errors (from among 100s).. but I took the last known backup and took it to another SQL 2005 database server and restored there successfully.. there CHECKDB is not giving any error... hence trying to want to know for sure if there is corruption or not..

-------------
Msg 8951, Level 16, State 1, Line 2
Table error: table 'FOI' (ID 884718750). Data row does not have a matching index row in the index 'IDXFOI_StatusProg' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 2
Data row (1:672533:8) identified by (PEG_ID = 362443) with index values 'StatusCtgCode = 'CFC' and Route_Class = 201 and StatusCode = 'H8' and PEG_ID = 362443'.

Msg 8952, Level 16, State 1, Line 2
Table error: table 'FLOATS' (ID 1929838733). Index row in index 'IDX_FLOATS_StatusGroups' (ID 32) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 2
Index row (1:652523:90) with values (StatusCtgCode = 'CFC' and Cust_ID = 5092 and VersionMajor = 1 and VersionMinor = 6 and App_ID = 25236) pointing to the data row identified by (App_ID = 25236).


Msg 8978, Level 16, State 1, Line 2
Table error: Object ID 1425752482, index ID 2, partition ID 72057609129426944, alloc unit ID 72057609721020416 (type In-row data). Page (1:674087) is missing a reference from previous page (1:655168). Possible chain linkage problem.


Msg 2533, Level 16, State 2, Line 2
Table error: page (1:674032) allocated to object ID 591562137, index ID 1, partition ID 72057607758020608, alloc unit ID 72057608325693440 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

Msg 8905, Level 16, State 1, Line 2
Extent (1:673888) in database ID 9 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

Msg 8964, Level 16, State 1, Line 2
Table error: Object ID 281481223, index ID 1, partition ID 72057606850084864, alloc unit ID 72057594384482304 (type LOB data). The off-row data node at page (1:674072), slot 0, text ID 1382678528 is not referenced.

Msg 8976, Level 16, State 1, Line 2
Table error: Object ID 591562137, index ID 1, partition ID 72057607758020608, alloc unit ID 72057608325693440 (type In-row data). Page (1:674032) was not seen in the scan although its parent (1:4437) and previous (1:281283) refer to it. Check any previous errors.

Msg 8935, Level 16, State 1, Line 2
Table error: Object ID 884718750, index ID 62, partition ID 72057609129623552, alloc unit ID 72057609721217024 (type In-row data). The previous link (1:674002) on page (1:661235) does not match the previous page (1:661234) that the parent (1:660874), slot 43 expects for this page.

Msg 8977, Level 16, State 1, Line 2
Table error: Object ID 884718750, index ID 62, partition ID 72057609129623552, alloc unit ID 72057609721217024 (type In-row data). Parent node for page (1:674002) was not encountered.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Looks like you having a disk issue here.
I would restore the last know backup if it was possible. You'll loose data anyway.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

25112Author Commented:
ok.. now, back to the original question..

I have restored from last known backup, but how can I confirm that the restored it 100% good. is checkDB good enough or the only golden option to confirm/deny corruption of data?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, CHECKDB will give you the assurance that your data has no corruptions.

PS: You opened like 3 questions about the same issue.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
25112Author Commented:
thank you Vitor!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.