Errors 823, 834, and 825 are all related to I/O errors in SQL Server. These errors occur when SQL Server is unable to read or write data to the disk due to a hardware or software failure. Error 823 “I/O error (torn page) detected during read at offset,” indicates that SQL Server has detected a torn page on the disk. …
SQL Server Alert System: ‘Severity 20 – Fatal Error In Current Process’DESCRIPTION: SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed [CLIENT: 192.168.1.xxx] With SQL Server alerting turned to for some of …
Part of good server monitoring it to have alerts enabled for a number of different errors to know when things go bad. The problem is we were getting the following error every time the server was restarted. SQL Server Alert System: ‘ERROR 824’ occurred on \\MyServerNameDESCRIPTION: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xe660dd36; actual: 0xcd481907). …