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