Monday, March 26, 2012

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.

No comments:

Post a Comment