Solved

checkdb- final authority on if db is corrupt?

Posted on 2014-09-10
6
192 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
  • 3
  • 3
6 Comments
 
LVL 48

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 48

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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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 48

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

829 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