ALTER DATABASE YourDB SET EMERGENCY; ALTER DATABASE YourDB SET SINGLE_USER; DBCC CHECKDB (YourDB, REPAIR_FAST); -- Minimal repair -- Or use: DBCC CHECKDB (YourDB, REPAIR_REBUILD); ALTER DATABASE YourDB SET ONLINE; ALTER DATABASE YourDB SET MULTI_USER;
Before attempting a fix, perform the following diagnostic checks: sql recovery pending
Several factors can contribute to a database entering a Recovery Pending state, including: ALTER DATABASE YourDB SET EMERGENCY; ALTER DATABASE YourDB