Reporting Services TempDB keeps going into restoring mode 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.
Why are you running a log backup job on [ReportServerQA5TempDB]? It should be in simple mode.

From MSDN:


  ReportServerTempdb is created with the primary report server database and is used to store temporary data, session information, and cached reports.


and


  Use the simple recovery model to backup the reportservertempdb database.


Now the real question becomes, "What are you using for your backups?" Check to make sure that it's not changing the recovery model and that ReportServerTempDB is still in SIMPLE recovery model.

    SELECT name, recovery_model_desc
        FROM sys.databases;


I wonder if your solution is trying to switch back and forth between recovery models and is failing somewhere along the way. I have a vague recollection of this having happened to me in the past. 

Try changing the recovery model to Simple and removing it from your hourly log backup job.

ALTER DATABASE ReportServerQA5TempDB SET RECOVERY SIMPLE;
GO