I am looking into an issue with SQL Server 2008 Reporting Services. It has been working fine until yesterday morning. Now I notice that
ReportServerTempDB keeps on going into
Restoring... mode. I restored it to online mode with
RESTORE DATABASE [ReportServerQ4TempDB] WITH RECOVERY.
The reports work fine after this and then after 10-15 minutes, then
ReportServerTempDB goes back into Restoring mode. Report execution gives the following error:
An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) For more information about this error navigate to the report server on the local server machine, or enable remote errors...
Any suggestions why it is doing that.
I have checked the following
- Memory - 50% available
- CPU - only 10% utilized
- Storage - 30% space remaining
There are multiple instance of SSRS running and SQL instance hosting the database for SSRS on the same server.
I have checked that AutoClose is not enabled for this database, and I have discovered that the database goes into
Restoring... mode every hour, when our log backup job runs.