How to Bring Database online from Recovery Pending in SQL Server - Expert's Strategy
You may have to use a professional repair tool if you need to fix a broken SQL server database. The software has the ability to search the MDF file for and recover important data from a corrupted SQL database.
Most of the time, it functions flawlessly and shows no issues while accessing database material. However, customers have sometimes seen the "sql database recovery pending" state, which results in the requirement to fix a corrupted SQL database. You can follow this write-up it will provide you with the methods to fix the recovery pending state in the SQL server.