Showing posts with label load. Show all posts
Showing posts with label load. Show all posts

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.
>

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 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.
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...
> 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.
> 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.
>