The Silent Standby: Understanding and Resolving SQL Server ‘Recovery Pending’
Your data is likely still on the disk, but SQL Server cannot safely bring the database online. sql server recovery pending
USE master; GO sp_detach_db 'YourDatabaseName'; GO sp_attach_db 'YourDatabaseName', 'C:\Data\YourDB.mdf', 'C:\Data\YourDB_log.ldf'; GO The Silent Standby: Understanding and Resolving SQL Server
If your SQL Server database is showing a status, it means the SQL Server service knows it needs to run a recovery process (to roll forward committed transactions and roll back uncommitted ones) but is currently blocked from doing so. GO sp_detach_db 'YourDatabaseName'