Friday, March 23, 2012

Restore stays in load status after restore norecovery

windows 2003, sql2000, sp3a - load 100gb database from a full backup (in EM)
and remains in load status (I was sure I had it set to recover). note: No t
ranslogs backups ever are produced for this db. No errors I believe when
it completed, although I di
d not look at the msg box too carefully, and clicked ok.
Although I later did a restore with norecovery anyway, it says the following
, any thoughts ?
thanks
Kw
file 'JDE_PRODUCTION_Data' was only partially restored by a database or file
restore. The entire file must be successfully restored before applying the
log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.sounds a bad backup. Can you reproduce the error by doing another restore
through Query analyzer?
"kw" <anonymous@.discussions.microsoft.com> wrote in message
news:03E527B2-999A-4DE8-8D2E-6EA3387C2E67@.microsoft.com...
quote:

> windows 2003, sql2000, sp3a - load 100gb database from a full backup (in

EM) and remains in load status (I was sure I had it set to recover). note:
No translogs backups ever are produced for this db. No errors I believe
when it completed, although I did not look at the msg box too carefully, and
clicked ok.
quote:

> Although I later did a restore with norecovery anyway, it says the

following, any thoughts ?
quote:

> thanks
> Kw
> file 'JDE_PRODUCTION_Data' was only partially restored by a database or

file restore. The entire file must be successfully restored before applying
the log.
quote:

> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>

No comments:

Post a Comment