Recent website change to the cloud server, after each operation for a period of time, it is possible that a few hours, may be a day or two, would be a BBS posts list cannot be displayed, list the following error System. The Data. SqlClient. SqlException: warning: serious mistakes after 2020 and 823 occurred in 08 27 PM into the server open event viewer "application", inside there will be a lot of error message: error: 823, severity: 24, state: 2
I/O error (bad page ID) detected during the read at offset 0 x0000007f0c4000 in the file 'D: \ SJK \ aaaaa_Data MDF'.

Search on the Internet a lot of methods, finally use the SQL statements below solution:

USE the MASTER
GO
Sp_dboption 'database name', 'single user', 'true'
Go
DBCC CHECKDB (' database name 'REPAIR_ALLOW_DATA_LOSS)
Go
USE 'database name'
Go
The exec sp_msforeachtable 'DBCC CHECKTABLE (''? , ' 'REPAIR_REBUILD)'
Go
Sp_dboption 'database name', 'single user', 'false'
Go

But after a few hours or a few days, the error will appear again, finally I found that as long as the database is shut, open again, can fix this error, but repaired, still can appear, this problem is really very big, want to know the brothers to help solve, thank you!

CodePudding user response:

I/O error 823 only when the operating system to perform data cyclic redundancy check fails to perform the operation, it is possible that the hard drive or hard disk data line is broken, try best to try to move to other places, MDF file best try will know, moved to the other hard disk is damaged by the hard disk

CodePudding user response:

reference 1st floor qq_457565758 response:

I/O error 823 only when the operating system to perform data cyclic redundancy check fails to perform the operation, may be a hard disk or hard disk data line is broken, it is best to try to try to move to other places, MDF file moved to other hard try best knew, isn't it hard disk was damaged

Moved to disk C, will appear

CodePudding user response:

I mean the physical hard disk is not your c drive D drive, E

CodePudding user response:

reference qq_457565758 reply: 3/f

I mean not your physical hard disk drive c D, E drive

Is the physical hard disk, I is the performance of disk c plate, E is capacity disk
Two different, but the problem is intermittent, sometimes his own good, really have a headache

CodePudding user response:

Do you have any questions you have to determine the hardware:
1, insufficient power is enough?
2, the hard disk that two wires are not qualified?

View the system log, system events; Performance monitoring

CodePudding user response:

Is the hard drive out of the question

CodePudding user response:

Is unlikely to ah, I use a cloud server, at the same time I was in two pieces of hard disk testing, is always the same, but I used DBCC CHECKDB detection, and did not return an error message, but as long as you use DBCC CHECKDB after testing, the 823 error will repair, but not return error message again, what is the reason?