Repair SQL Server with status (Recovery Pending) Posted by Unknown , Monday, June 26, 2017 at 1:25 PM, in

you can repair the issue using this script (this script is not mine)


Use [master]

EXEC sp_resetstatus RecoveryPendingModeDB

ALTER DATABASE RecoveryPendingModeDB SET EMERGENCY DBCC checkdb('RecoveryPendingModeDB')

ALTER DATABASE RecoveryPendingModeDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB('RecoveryPendingModeDB',REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE RecoveryPendingModeDB SET MULTI_USER

EXEC sp_resetstatus 'RecoveryPendingModeDB'




Replace RecoveryPendingModeDB with your actual database name with status 'Recovery Pending'.



You can read in detail here: https://www.zubairalexander.com/blog/how-to-fix-sql-server-databases-in-suspect-or-recovery-pending-mode/