-- 3. Bring database online – SQL will create a new empty log ALTER DATABASE YourDatabaseName SET ONLINE;
If step 3 fails with error 5120 or 5145, the database is stuck. Use this forced method: recovery pending sql
Unlike RECOVERING (where recovery is actively running) or SUSPECT (where recovery has definitively failed), RECOVERY PENDING means recovery cannot even begin . recovery pending sql