Member Avatar for suehoege

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.

  • 3 Contributors
  • 2 Replies
  • 77 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by Davidpoul

Recommended Answers

All 2 Replies

Member Avatar for sinnerFA

What version of SQL Server are you running?

Member Avatar for Davidpoul

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.

Edited by Ezzaral because: Snipped Advertising/promotion
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.