Recently site 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: severe error 2020 and 823 occurred in 08 27 PM into the server after open event viewer "application", it will be a lot of error: 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:

No man or woman??

CodePudding user response:

The post, you should be on SQL server edition piece is better,

This kind of mistake, two possibilities:
1, hardware out of the question;
2, the virtual machine is out of question,

Suggested that in a machine to try next,
Do you have a special ops, let they have is the best,
Some of the virtual machine storage is very poor, a problem is very normal,