Re: Msg (Loading) after db name
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 05/25/04
- Next message: Sean: "Optimise multitable update"
- Previous message: Rand Boyd [MSFT]: "RE: multihomed sql configuration"
- In reply to: David Chase: "Msg (Loading) after db name"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 25 May 2004 20:42:08 +0530
Hi,
Execute the below command from query analyzer:-
restore database <dbname> with recovery
Thanks
Hari
MCDBA
"David Chase" <dlchase@lifetimeinc.com> wrote in message
news:#qBVFFmQEHA.1960@TK2MSFTNGP10.phx.gbl...
> I wanted to restore a database to a new location on a different server. I
> did a backup to a file and then did a restore of that file onto the new
> server. I got a message that the restore was successful, but when I
opened
> Enterprise Manager the database had "(Loading)" after the database name
and
> was grayed out. When I tried to select properties it gave me "Error 927:
> Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
>
> Can anyone help? Thanks.
>
> David
>
>
- Next message: Sean: "Optimise multitable update"
- Previous message: Rand Boyd [MSFT]: "RE: multihomed sql configuration"
- In reply to: David Chase: "Msg (Loading) after db name"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
