You can try this SQL Query to fix recovery pending in SQL Server: ALTER DATABASE MyDB SET ONLINE