Cyclic Redundancy Check 1

[jpro]

I am restoring a database using a snapshot and during the restore process it gets to about 90% then errors out and stops.

The log says - Operating system error 23(Data error(cyclic redundancy check).)

I have since taken a new copy of the snapshot and tried again with the same issue.

Anybody ever run into this before?

Thanks.

 

[mrdenny]

Check your disk using chkdsk or some other hardware checking software. You may have hardware issues on the disk. Try backing up to another disk/array and restoring from there.

Also check your database for corruption via DBCC CHECKDB.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[jpro]

Thanks mrdenny!

I ran the chkdsk with the /v,/r &/f switches and everything went through on the restore the next time I ran it.



Great minds discuss "Ideas"
Average minds discuss "Events"
Below Average minds discuss "People

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)