Restore Completes (Loading)

I have SQL Server 2000 Enterprise Edition with SP3A on my
Windows 2000 Advanced Server. There is only one
development database on this server.
When I restore a backup from this database onto another
server in a similiar environment the restore completes.
But database icon status, states that it is loading. I
refresh the databases (PF5) but it does not change.
Next, I run the restore database with recovery and the
restore completes.
Please help me resolve this issue.
Mike
RESTORE DATABASE DATABASE_NAME
from disk = WITH RECOVERYAre you sure that the environment is the same, or that there are no pending
transactions? According to BOL, the WITH RECOVERY option IS the default
option, and should only be required when a database upgrade is required.
Steve
RECOVERY
Instructs the restore operation to roll back any uncommitted transactions.
After the recovery process, the database is ready for use.
If subsequent RESTORE operations (RESTORE LOG, or RESTORE DATABASE from
differential) are planned, NORECOVERY or STANDBY should be specified
instead.
If neither NORECOVERY, RECOVERY, or STANDBY is specified, RECOVERY is the
default. When restoring backup sets from an earlier version of SQL Server, a
database upgrade may be required. This upgrade is performed automatically
when WITH RECOVERY is specified. For more information, see Transaction Log
Backups .
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:1deb101c4548a$985d2e00$a401280a@.phx.gbl...
> I have SQL Server 2000 Enterprise Edition with SP3A on my
> Windows 2000 Advanced Server. There is only one
> development database on this server.
> When I restore a backup from this database onto another
> server in a similiar environment the restore completes.
> But database icon status, states that it is loading. I
> refresh the databases (PF5) but it does not change.
> Next, I run the restore database with recovery and the
> restore completes.
> Please help me resolve this issue.
> Mike
>
> RESTORE DATABASE DATABASE_NAME
> from disk => WITH RECOVERY
>|||HI,
It seems you have clicked the option "Non operational, need to load more
transaction logs" in enterprise manager while loading. Execute the below
command from query analyzer to recover the database:-
RESTORE DATABASE <dbname> with RECOVERY
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:1deb101c4548a$985d2e00$a401280a@.phx.gbl...
> I have SQL Server 2000 Enterprise Edition with SP3A on my
> Windows 2000 Advanced Server. There is only one
> development database on this server.
> When I restore a backup from this database onto another
> server in a similiar environment the restore completes.
> But database icon status, states that it is loading. I
> refresh the databases (PF5) but it does not change.
> Next, I run the restore database with recovery and the
> restore completes.
> Please help me resolve this issue.
> Mike
>
> RESTORE DATABASE DATABASE_NAME
> from disk => WITH RECOVERY
>