Solved

checkdb- final authority on if db is corrupt?

Posted on 2014-09-10
6
200 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 50

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 50

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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
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 50

Accepted Solution

by:
Vitor Montalvão earned 500 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

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

729 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