Following are the two manual ways that helps bring SQL database in recovery mode to normal mode:
1. Mark Database in Emergency Mode and Initiate Forceful Repair
2. Mark Database in Emergency Mode, Detach the Main Database and Re-attach It
If the above methods cannot help resolve the db in recovery pending state issue, use Stellar Repair for MS SQL software. The software can help you repair corrupt database files and bring the database back online from recovery pending state quickly and smoothly.
You can also read this helpful guide to know the reasons why a database is marked in recovery pending state. Also, it will describe methods to fix ‘SQL server database in recovery pending state’ problem.