?
Solved

checkdb- final authority on if db is corrupt?

Posted on 2014-09-10
6
Medium Priority
?
203 Views
Last Modified: 2014-09-10
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?
0
Comment
Question by:25112
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40314496
CheckDB will search for data corruption and that includes referential integrity.
What kind of corruption are you trying to find?
0
 
LVL 5

Author Comment

by:25112
ID: 40314537
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
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40314561
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 5

Author Comment

by:25112
ID: 40314571
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
 
LVL 51

Accepted Solution

by:
Vitor Montalvão earned 2000 total points
ID: 40314585
Yes, CHECKDB will give you the assurance that your data has no corruptions.

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

Author Comment

by:25112
ID: 40315232
thank you Vitor!
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question