Error 927

I recently restored a database from tape.
However when I go into SQL Enterprise Manager, I see the
recently restored database showing "loading".
I assumed that this was a good indication however it has
been loading now for the last 12 hours. The database is
about 17 gig.
Is this normal or is it safe to assume that is locked up.
What am I missing here.
Thank a million!
JamesIf you run sp_who2 do you see any RESTORE spids ? If not it may well be that
you just need to run RESTORE DATABASE dbname WITH RECOVERY to recover and
access the database.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<James@.discussions.microsoft.com> wrote in message
news:045601c3cfb6$8a186d40$a001280a@.phx.gbl...
> I recently restored a database from tape.
> However when I go into SQL Enterprise Manager, I see the
> recently restored database showing "loading".
> I assumed that this was a good indication however it has
> been loading now for the last 12 hours. The database is
> about 17 gig.
> Is this normal or is it safe to assume that is locked up.
> What am I missing here.
> Thank a million!
> James
>|||Hi James,
How did you restore the database? Are you using any third party tool?
Certain third party tool such as Arcserv may have option for you to
"recover" the database after the restore. If not, it will stay in
loading status until you recover the database manually
To recover the database manually, you can just run the following
statement
restore database <dbname> with recovery
Yih-Yoon Lee
<James@.discussions.microsoft.com> wrote in message news:<045601c3cfb6$8a186d40$a001280a@.phx.gbl>...
> I recently restored a database from tape.
> However when I go into SQL Enterprise Manager, I see the
> recently restored database showing "loading".
> I assumed that this was a good indication however it has
> been loading now for the last 12 hours. The database is
> about 17 gig.
> Is this normal or is it safe to assume that is locked up.
> What am I missing here.
> Thank a million!
> James

Error 927

I recently restored a database from tape.
However when I go into SQL Enterprise Manager, I see the
recently restored database showing "loading".
I assumed that this was a good indication however it has
been loading now for the last 12 hours. The database is
about 17 gig.
Is this normal or is it safe to assume that is locked up.
What am I missing here.
Thank a million!
JamesThat is really hard to tell. 12 hours sounds a bit excessive. What version
of SQL? I've restored 1-2 GB databases with SQL 7/2000 in 30 mins.
My one thought is that there may be a very long running transaction that has
to be rolled back. Do you have another backup to try restoring from? You
could always create a separate database on the same server, and force a
restore on that one.
Also, does sp_who reveal any blocks or ROLLBACK transactions? Where is
error 927 show up? When you restored, on the Advanced tab, it did say Leave
database operational, and not one of the other options where you could
restore additional backups, right?
I assume this KB article is not applicable as it is for the msdb database,
but I'll put in just in case
http://support.microsoft.com/defaul...kb;en-us;319701 (Error 927
restoring the msdb database).
Good luck.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
<James@.discussions.microsoft.com> wrote in message
news:045b01c3cfb6$9d4f18f0$a001280a@.phx.gbl...

quote:

---

> I recently restored a database from tape.
> However when I go into SQL Enterprise Manager, I see the
> recently restored database showing "loading".
> I assumed that this was a good indication however it has
> been loading now for the last 12 hours. The database is
> about 17 gig.
> Is this normal or is it safe to assume that is locked up.
> What am I missing here.
> Thank a million!
> James
>

---

sql