parminder.parmindersingh (2/8/2013)
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.
If you backed the database up immediately before shrinking it, one possibility might be to recreate the database and then restore from the backup.
Tom