Report Server uses Report Server Temporary database to store session and execution data, information related to cached reports. These tables in the ReporServerTemp database hold temporary data and th...
Published Nov 14, 2022
Version 1.0Blog Post
2 MIN READ
Report Server Temporary database configuration with Always on Availability groups in SQL server
Krishnakumar_Rukmangathan
Microsoft
Microsoft
The last sentence should read "As mentioned earlier, that the ReportServerTempDB database only stores Temporary data, removing it from Always On set Up will not cause any impact on Reporting Services.
If making the ReportServer database highly available, you will need to place a non-highly available copy of ReportServerTempDB database on each Failover replica.