How to get a database out of Recovery Pending state

One of my clients recently suffered an outage for their production environment. The database structure includes

  • Report Server
  • Report Server Temp
  • Transactional
  • Transaction History

During the outage all databases were in “Suspect” mode. I had never seen this status before, but it is not fun.
We suspect the cause of the issue was due to disk availability issues (the environment is virtually hosted), and SQL Server went into Suspect to protect itself.

After some time, the databases came back online by themselves with the exception of the ReportServerTempDB database. That changed to “Recovery Pending”.

I left the database for an hour to see if it could right itself, but no luck. I needed to help it get out of this recovery issue.

So, I applied the following script

ALTER DATABASE ReportServerTempDB SET OFFLINE WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE ReportServerTempDB SET ONLINE WITH ROLLBACK IMMEDIATE
GO

Success!

Subscribe

0 comments