Sunday, February 26, 2012

File Restore Problems

We have backed up a SQL 7.0 database to disk and am now
trying to restore it using the with move option to a
different device and with a different name.
The restore starts and fails after a fairly small amount
of time with the following message:
fcb::ZeroFile(): GetOverLappedResult() failed with error 2
It appears to initially create the .mdf file but deletes
it after the above message is received.
We have searched the web and found very little about this
problem. I suspect physical disk problems. I can restire
other smaller databases to the same device using the same
method with no trouble - but anything bigger fails also.
Anybody had anything similar and what did you do to
resolve the problem.
Thanks
David
I think the first step is to check your hardware (HD and RAID controller if
present) and then go to another issues linked with MS SQL errors... but for
me it's 99% a hardware problems
"David" <dave.whitehead@.cis.co.uk> wrote in message
news:dec601c43c15$89472f20$a401280a@.phx.gbl...
> We have backed up a SQL 7.0 database to disk and am now
> trying to restore it using the with move option to a
> different device and with a different name.
> The restore starts and fails after a fairly small amount
> of time with the following message:
> fcb::ZeroFile(): GetOverLappedResult() failed with error 2
> It appears to initially create the .mdf file but deletes
> it after the above message is received.
> We have searched the web and found very little about this
> problem. I suspect physical disk problems. I can restire
> other smaller databases to the same device using the same
> method with no trouble - but anything bigger fails also.
> Anybody had anything similar and what did you do to
> resolve the problem.
|||Try coping a large file to the destination drive(size almost similar to the database), using windows explorer and check what error do you get. Also check if any disk quota has been set.

No comments:

Post a Comment