Report server database (SSRS native mode)

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. By default, the database names are ReportServer and ReportServerTempDB, respectively.

A SharePoint mode Reporting Services installation also creates a database for the data alerting feature. The three databases in SharePoint mode are associated with Reporting Services service applications. For more information, see Manage a Reporting Services SharePoint service application

The databases can run on a local or remote Database Engine instance. Choosing a local instance is useful if you have sufficient system resources or want to conserve software licenses, but running the databases on a remote computer can improve performance.

You can port or reuse an existing report server database from previous installation or a different instance with another report server instance. The schema of the report server database must be compatible with the report server instance. If the database is in an older format, you're prompted to upgrade it to the current format. Newer versions can't be down graded to an older version. If you have a newer report server database, you can't use it with an earlier version of a report server instance. For more information about how report server databases are upgraded to newer formats, see Upgrade a report server database.

Important

The table structure for the databases is optimized for server operations and should not be modified or tuned. Microsoft might change the table structure from one release to the next. If you modify or extend the database, you might limit or prevent the capability to perform future upgrades or apply service packs. You might also introduce changes that impair report server operations. For example, if you turn on READ_COMMITTED_SNAPSHOT on the ReportServer database, you break the interactive sorting feature.

All access to a report server database must be handled through the report server. To access content in a report server database, you can use report server management tools. These tools include the web portal and SQL Server Management Studio), or programmatic interfaces such as URL access, Report Server Web service, or the Windows Management Instrumentation (WMI) provider.

The connection to the report server database is defined through the Reporting Services Configuration Manager. However, it can be defined during setup if you choose to install the default configuration. For more information about the report server connection to the database, see Configure a report server database connection (Report Server Configuration Manager).

Report server database

The report server database is a SQL Server database that stores the following content:

  • Items managed by a report server. These items include reports and linked reports, shared data sources, report models, folders, resources, and all of the properties and security settings that are associated with those items.

  • Subscription and schedule definitions.

  • Report snapshots (which include query results) and report history.

  • System properties and system-level security settings.

  • Report execution log data.

  • Symmetric keys and encrypted connection and credentials for report data sources.

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 Move the report server databases to another computer (SSRS native mode).

Report server temporary database

Each report server database uses a related temporary database to store session and execution data, cached reports, and work tables that the report server generates. Background server processes periodically removes older and unused items from the tables in the temporary database.

Reporting Services doesn't re-create the temporary database if it's missing, nor does it repair missing or modified tables. Although the temporary database doesn't contain persistent data, you should back up a copy of the database anyway so that you can avoid having to re-create it as part of a failure recovery operation.

If you back up the temporary database and then restore it, you should delete the contents. Generally, it's safe to delete the contents of the temporary database at any time. However, you must restart the Report Server Windows service after you delete the contents.