Run this in a new query window in SSMS (replace YourDatabaseName ):

SQL Server Error: “Recovery Pending” – Causes and Step-by-Step Fixes

-- Then drop and re-add the log (replace 'YourDB_log' with your logical name) ALTER DATABASE YourDatabaseName REMOVE FILE YourDB_log; ALTER DATABASE YourDatabaseName ADD LOG FILE (NAME = YourDB_log, FILENAME = 'C:\YourPath\YourDatabaseName_log.ldf');

-- 3. Rebuild the log file DBCC CHECKDB (YourDatabaseName, REPAIR_ALLOW_DATA_LOSS);