While executing a shrink on a 25GB database, the electricity has gone down, and I can't access my database. It shows as "In Recovery".
How can I recover it?
|show 4 more comments|
Look into the sql server logs to see how much percent has been recovered. Find any errors in sql server logs as well as eventviewer.
If the situation does not improves in sometime, you may need to take the db into emergency mode to see what actually happened.