Sql Server Recovery Pending Work -

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

-- 3. Attempt to repair the database (allow data loss) ALTER DATABASE YourDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE; DBCC CHECKDB (YourDatabaseName, REPAIR_ALLOW_DATA_LOSS); ALTER DATABASE YourDatabaseName SET MULTI_USER; sql server recovery pending

-- 1. Put database in Emergency mode ALTER DATABASE YourDatabaseName SET EMERGENCY; -- 2. Set to single user ALTER DATABASE YourDatabaseName SET SINGLE_USER; Run this in a new query window in