Views:
User got below error:
 
Application Name:     AdvWQOE
Module Name:              frmQuickOE
Function/Sub Name: pSaveOrder
Error Number:               824
Line Number:                17574
Error Description:       SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x91a00367; actual: 0x84a1b31d). It occurred during a read of page (1:332543) in database ID 5 at offset 0x000000a25fe000 in file 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL12.ADVANCEWARE\MSSQL\DATA\AWJobsDB1.mdf'.  Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
App Version:                   6.00.0602
 
 
User had upgraded to Windows 11. Used the following steps to correct the issue:
Backup the AWJobsDB1 database before doing anything. First step seems to have corrected the issue.

If there is recent enough backup of the database, you could try restoring it.  If restoring a backup is not an option, in a new query window in SSMS run the following:

ALTER DATABASE [AWJobsDB1]
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO

DBCC CHECKDB('AWJobsDB1', REPAIR_ALLOW_DATA_LOSS);
GO

ALTER DATABASE [AWJobsDB1]
SET MULTI_USER;
GO

If the error still occurs after this completes, you can run the following, which allows for data loss:

ALTER DATABASE [AWJobsDB1]
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO

DBCC CHECKDB('AWJobsDB1', REPAIR_REBUILD);
GO

ALTER DATABASE [AWJobsDB1]
SET MULTI_USER;
GO
 
Keywords: 824,error,save