My database is entered in recovery mode due to power loss while executing query! I have tried a lot of queries but i am unable to resolve that problem

1 Answer 1


I would start with:

Restore database <db_name> with recovery

If that is not working look at the "Current" "SQL Server Logs" and check for errors.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.