Contents
Where is the report server database stored in SSMS?
The default path is C:\Program Files\Microsoft SQL Server\MSSQL. 3\Reporting Services\RSTempFiles. Unlike SQL Server’s tempdb, data in ReportServerTempDB survives SQL Server and Report Server restarts.
What is ReportServer and Reportservertempdb?
The ReportServer database has tables to store reports, data sources, snapshots, subscriptions, etc. It is the repository for the reporting application data. The ReportServerTempDB database is used for temporary storage needs, as the default name suggests.
Does SSRS store data?
Because the report server database stores application state and persistent data, you should create a backup schedule for this database to prevent data loss. For recommendations and instructions on how to back up the database, see Moving the Report Server Databases to Another Computer (SSRS Native Mode).
What is the use of ReportServerTempdb?
A Reporting Services deployment uses two SQL Server relational databases for internal storage. By default, the databases are named ReportServer and ReportServerTempdb. ReportServerTempdb is created with the primary report server database and is used to store temporary data, session information, and cached reports.
What is a ReportServer database?
A report server is a stateless server that uses the SQL Server Database Engine to store metadata and object definitions. A native mode Reporting Services installation uses two databases to separate persistent data storage from temporary storage requirements. The databases are created together and bound by name.
How do I restore a ReportServer database?
Start the Reporting Services Configuration tool and open a connection to the report server. On the Database page, select the new SQL Server instance, and then click Connect. Select the report server database that you just moved, and then click Apply. On the Encryption Keys page, click Restore.
How to connect to the Report Server database?
The report server databases are used internally by the report server. Connections to either database are made by the Report Server service. You use the Reporting Services Configuration tool to configure the report server connection to the report server database.
Why is the reportservertempdb database name invalid?
Invalid object name ‘ReportServerTempDB.dbo.PersistedStream’.” This error occurs because the ReportServerTempdb name is stored internally and used by stored procedures to perform internal operations. Renaming the temporary database will prevent the stored procedures from working properly.
How to administer report server database native mode?
To administer the report server databases, SQL Server provides a variety of tools. To back up or restore the report server database, move a report server database, or recover a report server database, you can use SQL Server Management Studio, the Transact-SQL commands, or the database command prompt utilities.
What are the names of the Report Server databases?
By default, the databases are named ReportServer and ReportServerTempdb. ReportServerTempdb is created with the primary report server database and is used to store temporary data, session information, and cached reports.