Error: 823, Severity: 24, State: 2 after restart database server
0
votes
1
answer
312
views
> SQLSTATE[HY000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0x0000b081cbc000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\DB_v4.mdf'. Additional messages in the SQL Server error log and operating system error log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately.
I have following error after restarting the database server. The main page that contains dropdown and select from the database is working, but will give an error when I try to save/login.
I try to query on SSMS, can login to database, and can perform query
SELECT TOP 100
, but if I try to INSERT
/COUNT
it gives an error:
> Error: 823, Severity: 24, State: 2.
Asked by Insko Malaysia
Dec 11, 2023, 06:36 AM
Last activity: Sep 17, 2025, 08:02 PM
Last activity: Sep 17, 2025, 08:02 PM