I have found following error on my MS-SQL server 2012

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

99 percent processed.
100 percent processed.
Processed 0 pages for database 'GCPL_V8', file 'GCPL_V8' on file 1.
Processed 1271734 pages for database 'GCPL_V8', file 'GCPL_V8_log' on file 1.
Msg 823, Level 16, State 2, Line 3
The operating system returned error 23(Data error (cyclic redundancy check).) to SQL Server during a read at offset 0x00001b75810000 in file 'K:\DataFiles\GCPL_V8.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Msg 3013, Level 16, State 1, Line 3
RESTORE LOG is terminating abnormally.

when restoring transaction log backup on DR.

restore log [GCPL_V8] from disk='J:\Transaction_LogFile_Copy\GCPL_V8\GCPL_V8_20200214234515.trn' with norecovery, stats=1

What I have tried:

In windows even log following erro occured.
When I see even log (Application) following error found

The operating system returned error 23(Data error (cyclic redundancy check).) to SQL Server during a read at offset 0x00001b75810000 in file 'K:\DataFiles\GCPL_V8.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

in system even following error found.

The device, \Device\Harddisk4\DR4, has a bad block.

My database is in restoring mode. so can not perform check db on database.
I have performed CHECKDB on my dc server (For same ) DB but no any error found.

Is my disk is corrupted.

Can i Restored transaction log backup on same DB or need to reconfigured database on another drive.

please suggest.

Posted 17-Feb-20 5:06am

paul_vin

Updated 17-Feb-20 8:57am

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2020-02-17T06:50:00

Solution 1

Quote:
Is my disk is corrupted.

Those error messages certainly indicate that it is. Time to save everything you can and restore to a new disk from backups.

Posted 17-Feb-20 6:50am

Richard MacCutchan

Patrice T · Answer 2 · 2020-02-17T07:09:00

Quote:
Is my disk is corrupted.

No, the disk is not corrupt, but the database is corrupt because of disk failure.

Quote:
error 23(Data error (cyclic redundancy check).)

This means physical error on HDD.
The only sensible action is replacing the HDD.
Cyclic redundancy check - Wikipedia[^]
A temporary action can be to invalidate the sector on HDD, but it is done with technical tools and is not recommended to newbes. The action is highly risked.
If data on your server is valuable, think about RAID storage.
RAID - Wikipedia[^]

MadMyche · Answer 3 · 2020-02-17T08:57:00

Time to break out the Disaster Recovery plan; as Windows has said there is a problem with the hard drive.

It is possible that there are things that may aid in recovery, but that would be something best left to people who are familiar with the tools.

And if you should need to replace the Hard Drive; I would recommend that you actually use physical discs and not a solid-state device for SQL data

Reference:
Fix SQL Database Cyclic Redundancy Check (CRC) Error[^]

I have found following error on my MS-SQL server 2012

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0