My project disappeared and the database seems to be stuck in a pending recovery
The “recovery pending" status may indicate that you are having the database to auto-close connections.
It should be on False for best performance.
If you are using SQL Server Express, it may default to Auto close true for all new databases. This can be changed in the 'Model' db.
There may be more info on why this happens in the SQL Server ERRORLOG found in a path similar to:
C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Log
If the database is still stuck in "recovery pending", restarting the SQL Server may alleviate the problem.
Check the database options 'Auto close' property:
