| title | Backup and restore operations for Reporting Services | |
|---|---|---|
| description | Backup and Restore Operations for Reporting Services | |
| ms.date | 09/25/2024 | |
| ms.service | reporting-services | |
| ms.subservice | report-server | |
| ms.topic | concept-article | |
| ms.custom |
|
This article provides an overview of all data files used in a [!INCLUDEssRSnoversion] installation and describes when and how you should back up the files. Developing a backup and restore plan for the report server database files is the most important part of a recovery strategy. However, a more complete recovery strategy would include backups of the encryption keys, custom assemblies or extensions, configuration files, and source files for reports.
[!INCLUDEapplies] [!INCLUDEssRSnoversion] Native Mode | [!INCLUDEssRSnoversion] SharePoint Mode
Note
Reporting Services integration with SharePoint is no longer available after SQL Server 2016.
Backup and restore operations are often used to move all or part of a [!INCLUDEssRSnoversion] installation:
-
If you're moving just the report server databases, you can use backup and restore or attach and detach to relocate the databases on a different [!INCLUDEssNoVersion] instance. For more information, see Move the report server databases to another computer (SSRS Native mode).
-
Moving a [!INCLUDEssRSnoversion] installation to a new computer is called a migration. When you migrate an installation, you run Setup to install a new report server instance and then copy instance data to the new computer. For more information about migrating a [!INCLUDEssRSnoversion] installation, see the following articles:
::: moniker range="=sql-server-2016"
::: moniker-end
Because a report server is a stateless server, all application data is stored in the reportserver and reportservertempdb databases that run on an [!INCLUDEssDEnoversion] instance. You can back up the reportserver and reportservertempdb databases using one of the supported methods for backing up [!INCLUDEssNoVersion] databases. Here are some recommendations specific to the report server databases:
-
Use the full recovery model to back up the reportserver database.
-
Use the simple recovery model to back up the reportservertempdb database.
-
You can use different backup schedules for each database. The only reason to back up the reportservertempdb is to avoid having to recreate it if there's a hardware failure. If you experience hardware failure, it isn't necessary to recover the data in reportservertempdb, but you do need the table structure. If you lose reportservertempdb, the only way to get it back is to recreate the report server database. If you recreate the reportservertempdb, it's important that it has the same name as the primary report server database.
For more information about backup and recovery of [!INCLUDEssNoVersion] relational databases, see Back up and restore of SQL Server databases.
::: moniker range="=sql-server-2016"
Important
If your report server is in SharePoint mode, there are additional databases to be concerned with, including SharePoint configuration databases and the [!INCLUDEssRSnoversion] alerting database. In SharePoint mode, three databases are created for each [!INCLUDEssRSnoversion] service application. The reportserver, reportservertempdb, and dataalerting databases. For more information, see Backup and restore Reporting Services SharePoint service applications
::: moniker-end
You should back up the encryption keys when you configure a [!INCLUDEssRSnoversion] installation for the first time. You should also back up the keys anytime you change the identity of the service accounts or rename the computer. For more information, see Back up and restore Reporting Services encryption keys.
::: moniker range="=sql-server-2016"
For SharePoint mode report servers, see the "Key Management" section of Manage a Reporting Services SharePoint service application.
::: moniker-end
[!INCLUDEssRSnoversion] uses configuration files to store application settings. You should back up the files when you first configure the server and after you deploy any custom extensions. Files to back up include:
-
Rsreportserver.config
-
Rssvrpolicy.config
-
ReportingServicesService.exe.config
-
Web.config for the Report Server [!INCLUDEvstecasp] application
-
Machine.config for [!INCLUDEvstecasp]
Back up the files that you create and maintain in Report Designer. These include report definition (.rdl) files, shared data source (.rds) files, data view (.dv) files, data source (.ds) files, report server project (.rptproj) files, and report solution (.sln) files.
Remember to back up any script files (.rss) that you created for administration or deployment tasks.
Verify that you have a backup copy of any custom extensions and custom assemblies you're using.