sql server connect: 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

That 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/default.aspx?scid=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.

*******************************************************************
[quoted text, click to view]

It could be that the restore operation has already
finished, but you might have restored the database WITH
NORECOVERY. If that's the case, the Enterprise Manager
would show the database as loading until you recover it.

To recover the database, run

RESTORE DATABASE yourDB WITH RECOVERY

The '(Loading)' string after the database name in EM
should then go away.

Linchi

[quoted text, click to view]