June 22, 2010 at 10:06 am
Hi,
i was retoring a database and it stop abnormally with the below error:
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
100 percent processed.
Processed 30537536 pages for database 'Master_Automate', file 'Master_Automate_dat' on file 1.
any idea Guys
thanks
Puneet
Processed 28806616 pages for database 'Master_Automate', file 'MASTER_AUTOMATE_IDX' on file 1.
Processed 165 pages for database 'Master_Automate', file 'Master_Automate_log' on file 1.
Processed 85853 pages for database 'Master_Automate', file 'MASTER_AUTOMATE_1_Log' on file 1.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Msg 823, Level 24, State 5, Line 1
The operating system returned error 23(Data error (cyclic redundancy check).) to SQL Server during a read at offset 0x00000001420000 in file 'F:\Master_Automate_3.Master_Automate_log2'. 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 5159, Level 17, State 2, Line 1
Operating system error 23(Data error (cyclic redundancy check).) on file "F:\Master_Automate_3.Master_Automate_log2" during RestoreFileHdrCond.
June 22, 2010 at 10:23 am
Looks like either the log (in the backup) is damaged or you have hard drive problems. Can you try and restore on another server and see if it works.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2010 at 1:33 am
Thanks For Your Reply Gail,
My backup file is close to 500 GB so let me get that space on testing server, will let you know once done.
Thanks
Puneet
June 23, 2010 at 5:12 am
See of this link can help you.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104090
http://www.eggheadcafe.com/forumarchives/SQLServerserver/Jul2005/post23536458.asp
this error generally comes when there is corruption in data.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 23, 2010 at 5:17 am
Bhuvnesh (6/23/2010)
this error generally comes when there is corruption in data.
Check the error. It's the log file that its complaining about, not the data file.
I'm not sure how valid those links are. They're talking about CheckDB erros (and very different ones), not a CRC error on a restore.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2010 at 5:24 am
Hey,
I checked OS Log and found:
The file system structure on the disk FreeAgent Drive is corrupt and unusable.
FreeAgent Drive is the drive i copied the Backup file, so may be this Drive corruption created all issue.
will let you know once get somthing.
thanks
Puneet
June 23, 2010 at 5:27 am
You'll probably have to get a new backup if the drive that it was on is faulty.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply