VirtualCentre SQL in recovery

[Albo42]

Hello,

the VirtualCentre SQL database is in Recovery mode. Both the Database and transaction logs are of the same size  (2, 097, 152KB) and the the VirtualCentre service will not start as it cannot log onto the database.

If I select properties of the database , I am unable to edit the log size etc. Do not appear to be able to do this while it says it is in recovery.

Can anyone suggest what I can do here to get this back online?

Thanks

ps. I have some SQL experience.

[Virtualinfra]

Refer the KB articles.

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=100104...

To change the recovery mode refer below.

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=100398...

[Albo42]

Hi,

thanks for reply. When I right =click the database,, I am unable to select properties. Nothing happens.....just an hour glass.

[Virtualinfra]

Please attache the screen shot..

[Albo42]

Hi,

screen-shot attached.

Thanks