Hello everyone,

While writing to the SQL Server database, I might encounter the below error message:
“Error 823
I/O error <error> detected during <operation> at offset <offset> in file
'<file>'”
This error message may occur every time when I start SQL Server and access the MDF file.

Thanks in advance.

What version of SQL Server are you running?

Use DBCC CHECKDB command to check any logical errors in the database. It is an in-built command in SQL Server to fix application level errors. Else you have to use third party SQL Database Recovery software to scan the corrupted database and recover all the inaccessible data from it. These software are specifically designed to Repair SQL database in most of the corruption scenarios. I hope your problem will be resolved by using DBCC CHECKBD Command.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.