SQL Server detected a logical consistency-based I/O error

Question

SQL Server detected a logical consistency-based I/O error

Gurumoorthy Mani 40

Hi, I am struggling to find the permanent solution for this error. This error is replicating multiple times per day. Restoring the database is the only option to resolve this problem. After restored, the database is accessible but when we initiate the SQL Job schedules, then the same error is replicating again. We don't know the reason for this problem. Please provide me a permanent for this error. User's image

Accepted answer

2 additional answers

Your answer

Answer 1

Erland Sommarskog 121.4K MVP Volunteer Moderator

For your description it seems that you have serious hardware problems. The biggest culprit is the I/O subsystem, but it could be a bad memory stick as well. You should absolutely move to new hardware.

Gurumoorthy Mani 40 Reputation points

2024-01-24T05:56:21.0666667+00:00

Thanks Erland for the reply. Surely, I will modify the hardware and will check
Gurumoorthy Mani 40 Reputation points

2024-01-25T07:52:22.13+00:00

Hi Erland, This post is really helpful for us. We dropped the database and Re-created the database and restored the database form backup. Two days, there will be no issues. and also we sent mail to DBA for checking hardware, they are also suspected in hard drive.

Answer 2

Olaf Helper 47,436

One reason could be a storage failure; have you check your storgae?

Gurumoorthy Mani 40 Reputation points

2024-01-23T08:05:52.0833333+00:00

Hi Olaf, Thanks for the response. I have verified the storage, its has enough storage in hard drive.
Gurumoorthy Mani 40 Reputation points

2024-01-23T10:45:40.6633333+00:00

Hi Olaf, Whenever we face issues, with the help of DBCC Command. we got some object ID of the tables. it seems that, the tables get repaired. That tables size are huge, it around more than 500K rows. we truncated the table and took backup. After, we access the tables from that database either via SSRS report or SQL job schedules. Again we are facing the same issue. If we are trying to restore the recent backup, restore will get failed. If we restore the old backup which has more number of rows in tables get succeeded. Please help me to sort out this problem.
Olaf Helper 47,436 Reputation points

2024-01-24T06:56:38.4566667+00:00

its has enough storage in hard drive.

The free size doesn't matter in any way, some of the disk / sectors are corrupt and if so, you can restore the database as often as you like, you will get the same error again.

Answer 3

LiHongMSFT-4306 31,566

Hi @Gurumoorthy Mani Try troubleshooting follow by this article: Troubleshooting and Fixing SQL Server Page Level Corruption.

Best regards,

Cosmog Hong

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Gurumoorthy Mani 40 Reputation points

2024-01-24T08:36:08.2733333+00:00

Hi Cosmog Hong The Article is really helps to figure out the problems. Issues has been resolved, but when we are accessing the tables via SSRS reports or CRM job schedule. This database Corruption is repeating again and again. And also the same issue reflecting to other database too.
LiHongMSFT-4306 31,566 Reputation points

2024-01-24T09:08:19.8433333+00:00

Hi Did you try move to new hardware as Erland suggested?
Gurumoorthy Mani 40 Reputation points

2024-01-24T10:40:23.75+00:00

Yes, Just now raised ticket to System administrator..

Share via

SQL Server detected a logical consistency-based I/O error

2 additional answers

Your answer