DBCC Checkdb - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

DBCC Checkdb

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-09-05 : 09:31:47

Ricardo writes "We are consistently getting this error. We have check the hardware and nothing appears in the checkdk, can you help.

Thanks

Ricardo

dbcc checkdb (virtualrequest)
DBCC results for 'tblVRAnswers'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 370256524, index ID 3: Page (1:243518) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 370256524, index ID 3, page (1:243518). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
There are 9608 rows in 106 pages for object 'tblVRAnswers'.

CHECKDB found 0 allocation errors and 2 consistency errors in database 'VirtualRequest'.

dbcc checkdb (virtualrequest)
DBCC results for 'tblvrquestions'.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'VirtualRequest', index 'tblVRRequestedItems.IX_NC_tblVRRequestedItems_CurrentStatusID' (ID 784825958) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:214293:372) with values (CurrentStatusID = 3 and RequestedItemID = 413260) points to the data row identified by ().
There are 6614 rows in 103 pages for object 'tblvrquestions'.

CHECKDB found 0 allocation errors and 1 consistency errors in database 'VirtualRequest'

dbcc checkdb (virtualrequest)
DBCC results for 'tblvrquestions'.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'VirtualRequest', index 'tblVRRequestedItems.IX_NC_tblVRRequestedItems_CurrentStatusID' (ID 784825958) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:214293:372) with values (CurrentStatusID = 3 and RequestedItemID = 413260) points to the data row identified by ().
There are 6614 rows in 103 pages for object 'tblvrquestions'.

CHECKDB found 0 allocation errors and 1 consistency errors in database 'VirtualRequest'."

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-09-06 : 12:35:11

Can you tell me the time interval between the CHEKCDB outputs you posted? The 2nd and 3rd outputs are the same. Are you getting any runtime errors?

The first output shows that you had a IO error on the page during read (the 2057 = 0x809, 0x800 indicates an IO error). Did you check the SQL error log and the Windows event logs?

Thanks

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources