.NET Daily

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

Introduction

Darius

Darius

Darius Dumitrescu is a creative Senior CMS Consultant with in depth .NET knowledge, focused on Web Development and Architecture Design.


LATEST POSTS

My View of a JIRA Workflow for Web Development 17th April, 2018

How to Remove a Profile Card or Key in Sitecore 8.2 10th March, 2018

SQL

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

Posted on .

If you happen to receive the exception from the title, 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:

In my particular case, it worked without breaking anything.
By the way, try to execute the entire script block at once. I tried first the DBCC CHECKDB statement but then I got some back and forth exceptions about MULTI_USER/SINGLE_USER modes.
You can read more about the DBCC CHECKDB options here.

Darius

Darius

Darius Dumitrescu is a creative Senior CMS Consultant with in depth .NET knowledge, focused on Web Development and Architecture Design.

There are no comments.

View Comments (0) ...
Navigation