One of my clients recently suffered an outage for their production environment. The database structure includes
- Report Server
- Report Server Temp
- 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