How long does a load take after a restore?

I performed a restore from a full backup and afterwards the database says it
's loading and is greyed out insteady of being yellow. It won't let me do a
nything, but gives no indication how long it will take to finish loading. T
he database is about 950mb.
Does anyone have any idea how long it should take? It's been 3 hrs so far a
nd I'm wanting to get back online as soon as possible.Hi,
It seems you have resored the database with NORECOVERY option. This options
needs to be selected if you have more transaction logs to be loaded.
Incase if you do not have any tranasctions logs to load execute the below
command to make the database online:
Restore database <DBNAME> with recovery
Note:
Replace the DBNAME with the actual database name.
Thanks
Hari
MCDBA
"Curt" <byteofram@.yahoo.com> wrote in message
news:1CF913CC-57C4-40F5-AA51-1D5E387BC867@.microsoft.com...
> I performed a restore from a full backup and afterwards the database says
it's loading and is greyed out insteady of being yellow. It won't let me do
anything, but gives no indication how long it will take to finish loading.
The database is about 950mb. Does anyone have any idea how long it should
take? It's been 3 hrs so far and I'm wanting to get back online as soon as
possible.