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.