Restore database status displays Loading

Hello, I'm trying to restore one of our sql2k database and in Enterprise
Manager console it is greyed out and says (Loading). Can anyone help?
Thanks in advance.Did you refresh after the RESTORE operation? If not, do refresh.
Also, did you do the RESTORE using NORECOVERY? If not, do below:
RESTORE DATABASE dbname WITH RECOVERY
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"zz12" <IDontLikeSpam@.Nowhere.com> wrote in message news:OUmw8fOEIHA.3636@.TK2MSFTNGP03.phx.gbl...
> Hello, I'm trying to restore one of our sql2k database and in Enterprise
> Manager console it is greyed out and says (Loading). Can anyone help?
> Thanks in advance.
>|||I right clicked it and surprisingly it allowed me to redo the Restore
process which then seemed to went through ok.
Thanks a bunch Tibor for your speedy and helpful reply. Much appreciated.
Cheers :-)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:6A73EF4C-F945-4BA7-B7B1-416656A35B4A@.microsoft.com...
> Did you refresh after the RESTORE operation? If not, do refresh.
> Also, did you do the RESTORE using NORECOVERY? If not, do below:
> RESTORE DATABASE dbname WITH RECOVERY
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "zz12" <IDontLikeSpam@.Nowhere.com> wrote in message
> news:OUmw8fOEIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> Hello, I'm trying to restore one of our sql2k database and in Enterprise
>> Manager console it is greyed out and says (Loading). Can anyone help?
>> Thanks in advance.

Restore a Suspect Database

Is there a quick way of restoring a suspect database without recycling the
services ?. I did set the status to -32768 and moving the database into
another database..........Any other (Easier way) ?
Thanks.
DXC
Last good backup of this database
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:9C67B96A-312B-41E7-9F38-48A12D8BD7D9@.microsoft.com...
> Is there a quick way of restoring a suspect database without recycling the
> services ?. I did set the status to -32768 and moving the database into
> another database..........Any other (Easier way) ?
>
> Thanks.
>
|||You need a good backup
or
If its not available.
Try to export tables data using DTS.
May be you are successful to import the tables if that one is not
corrupted.
Regards
|||That is OK..........For some reason when I delete (Dropped) the database,
it did not delete the *.mdf and *.ldf files. Then I was able to attached the
database......
"DXC" wrote:

> Is there a quick way of restoring a suspect database without recycling the
> services ?. I did set the status to -32768 and moving the database into
> another database..........Any other (Easier way) ?
>
> Thanks.
>

Restore a Suspect Database

Is there a quick way of restoring a suspect database without recycling the
services ?. I did set the status to -32768 and moving the database into
another database..........Any other (Easier way) ?
Thanks.DXC
Last good backup of this database
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:9C67B96A-312B-41E7-9F38-48A12D8BD7D9@.microsoft.com...
> Is there a quick way of restoring a suspect database without recycling the
> services ?. I did set the status to -32768 and moving the database into
> another database..........Any other (Easier way) ?
>
> Thanks.
>|||You need a good backup
or
If its not available.
Try to export tables data using DTS.
May be you are successful to import the tables if that one is not
corrupted.
Regards|||That is OK..........For some reason when I delete (Dropped) the database,
it did not delete the *.mdf and *.ldf files. Then I was able to attached the
database......
"DXC" wrote:
> Is there a quick way of restoring a suspect database without recycling the
> services ?. I did set the status to -32768 and moving the database into
> another database..........Any other (Easier way) ?
>
> Thanks.
>

Restore a Suspect Database

Is there a quick way of restoring a suspect database without recycling the
services ?. I did set the status to -32768 and moving the database into
another database..........Any other (Easier way) ?
Thanks.DXC
Last good backup of this database
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:9C67B96A-312B-41E7-9F38-48A12D8BD7D9@.microsoft.com...
> Is there a quick way of restoring a suspect database without recycling the
> services ?. I did set the status to -32768 and moving the database into
> another database..........Any other (Easier way) ?
>
> Thanks.
>|||You need a good backup
or
If its not available.
Try to export tables data using DTS.
May be you are successful to import the tables if that one is not
corrupted.
Regards|||That is OK..........For some reason when I delete (Dropped) the database,
it did not delete the *.mdf and *.ldf files. Then I was able to attached the
database......
"DXC" wrote:

> Is there a quick way of restoring a suspect database without recycling the
> services ?. I did set the status to -32768 and moving the database into
> another database..........Any other (Easier way) ?
>
> Thanks.
>