SQL Server 823,824 Error

First:

The 823 error only indicates that SQL Server encountered a WinDOS read or write failure while requesting a page read and write to the operating system. 823 errors occur when a read-write request occurs

is not related to read and write content. 823 has nothing to do with SQL Server itself. This is usually caused by physical file corruption, or it can be a driver issue. If a file always appears

823 error, either the file has been badly damaged, or the hardware is out of the question.

Second:

824 Description SQL Server detected a logic error in the page.

1, checksum.

2, torn page torn pages, such as power problems, only a portion of the fatal page is written to the hard disk.

3, Short Tran read less than expected data, such as reading a page can return 8K but only returned 4 K.

4, bad page ID to read the 100th page of the data can be returned is 200 pages.

SQL Server 823,824 Error