.NET Daily

Recommended Resources

Popular Content

Taglogical consistency-based I/O error


How To Solve: SQL Server detected a logical consistency-based I/O error: invalid protection option.

Posted on March 19th, 2018.

If you happen to receive the logical consistency-based I/O error, then your database probably ended up in an unusable state. SQL Server provide some options to repair it but it does that with the risk of potentially losing data. The syntax that I used to repair it is the following: ALTER DATABASE MyBrokenDB SET SINGLE_USER WITH ROLLBACK...