Msg (Loading) after db name

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
Sounds like you might have left your database in a state where you can
restore a differential or additional transaction logs. Could you possibly
have restored using the "NORECOVERY" options, or set the "Leave Database
nonoperation...." radio button when doing your restore.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23qBVFFmQEHA.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
>
|||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
>
|||Yup. That was it...had the "Leave database nonoperation..." radio boxed
checked. Thanks.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Msg (Loading) after db name

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.
DavidSounds like you might have left your database in a state where you can
restore a differential or additional transaction logs. Could you possibly
have restored using the "NORECOVERY" options, or set the "Leave Database
nonoperation...." radio button when doing your restore.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23qBVFFmQEHA.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
>|||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
>|||Yup. That was it...had the "Leave database nonoperation..." radio boxed
checked. Thanks.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!