Restore Tranaction log

I am trying to restore a Transaction Log in SQL Server 2000 in Full recovery status, However I was received the following error Message:
----------------------------------------
Error message: Exclusive access could not be obtained because the database is in use.
----------------------------------------
Also I changed the UserAccess database from MULTI_USER to SINGLE_USER, but still do not work and shows the same error message.
Please let me know, if you have any solution for this problem.

Thanks,

Try the link below to test drive Lumigent. Hope this helps.
http://www.lumigent.com/

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