Solved

checkdb- final authority on if db is corrupt?

Posted on 2014-09-10
6
185 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 45

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 45

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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
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 45

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

708 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now