• I was shrinking a database, where its stuck and SSMS goes in not responding. I had wait till half an hour but no luck.

    then i just went to the respective server and restart the SQL server service into the SQL Configuration management. When i came back to my pc and contact to server it shows 4 database "In Recovery" mode. I was shocked, because all my live databases. These all databases on SQL Server 2005 SP1.

    And checked SQL error log got those details which i had posted on my earlier post. Please guide me, how i can make it correct.