I/O error 23(Data error (cyclic redundancy check)

5 pts.
Tags:
DBCC
SQL
SQL Query
I have encountered the below error message when I try to do SQL query.
Server: Msg 823, Level 24, State 2, Line 1
I/O error 23(Data error (cyclic redundancy check).) detected during read at offset 0x000001ac1c4000 in file 'C:sqlPDB_Data.mdf'.
Did a DBCC CHECKDB (PDB) WITH NO_INFOMSGS, ALL_ERRORMSGS and below is the result.
Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:72792) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.
Server: Msg 8921, Level 16, State 1, Line 1
CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:72792) with latch type UP. 菴恟 failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:72792) with latch type UP. 菴恟 failed.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 8 pages from (1:72792) to (1:80879). See other errors for cause.
CHECKDB found 2 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB found 2 allocation errors and 1 consistency errors in database 'PDB'.
Hope to get some help on what can I do. Do not have a clean back up of it. P.S. Have no idea on what the Chinese text are. Every time I run the DBCC CHECKDB, the Chinese text is always different. Thanks in advance. Ron

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    What does your SQL statement look like?
    84,555 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: