報表伺服器資料庫 (SSRS 原生模式)Report Server Database (SSRS Native Mode)

報表伺服器是使用 [SQL Server]SQL Server Database EngineDatabase Engine 儲存中繼資料和物件定義的無狀態伺服器。A report server is a stateless server that uses the [SQL Server]SQL Server Database EngineDatabase Engine to store metadata and object definitions. 原生模式 Reporting ServicesReporting Services 安裝會使用兩個資料庫來分隔永續性資料儲存與暫時儲存需求。A native mode Reporting ServicesReporting Services installation uses two databases to separate persistent data storage from temporary storage requirements. 兩個資料庫會一起建立,並依名稱繫結。The databases are created together and bound by name. 根據預設,資料庫名稱分別為 ReportServerReportServerTempdbBy default, the database names are reportserver and reportservertempdb, respectively.

SharePoint 模式 Reporting ServicesReporting Services 安裝也會針對資料更改功能建立資料庫。A SharePoint mode Reporting ServicesReporting Services installation will also create a database for the data alerting feature. SharePoint 模式中的三個資料庫與 Reporting ServicesReporting Services 服務應用程式相關聯。The three databases in SharePoint mode are associated with Reporting ServicesReporting Services service applications. 如需詳細資訊,請參閱 管理 Reporting Services SharePoint 服務應用程式For more information, see Manage a Reporting Services SharePoint Service Application

資料庫可以在本機或遠端 Database EngineDatabase Engine 執行個體上執行。The databases can run on a local or remote Database EngineDatabase 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 will be prompted to upgrade it to the current format. 但是無法讓新版降級為舊版。Newer versions cannot be down graded to an older version. 如果您有新版的報表伺服器資料庫,您無法將其用於舊版的報表伺服器執行個體。If you have a newer report server database, you cannot use it with an earlier version of a report server instances. 如需如何將報表伺服器資料庫升級到新格式的詳細資訊,請參閱 升級報表伺服器資料庫For more information about how report server databases are upgraded to newer formats, see Upgrade a Report Server Database.

重要

資料庫的資料表結構會針對伺服器作業最佳化,而且不應該修改或微調。The table structure for the databases is optimized for server operations and should not be modified or tuned. MicrosoftMicrosoft 前後版次的資料表結構可能會變更。might change the table structure from one release to the next. 如果您修改或擴充資料庫,可能會限制或妨礙執行未來升級或套用 Service Pack 的功能。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. 例如,如果您在 ReportServer 資料庫上開啟 READ_COMMITTED_SNAPSHOT,您會中斷互動式排序功能。For example if you turn on READ_COMMITTED_SNAPSHOT on the ReportServer database, you will break the interactive sorting feature.

所有對報表伺服器資料庫的存取,都必須透過報表伺服器處理。All access to a report server database must be handled through the report server. 若要存取報表伺服器資料庫中的內容,您可以使用報表伺服器管理工具 (例如報表管理員和 [SQL Server]SQL Server Management StudioManagement Studio) 或程式設計介面 (例如 URL 存取、報表伺服器 Web 服務,或 Windows Management Instrumentation (WMI) 提供者)。To access content in a report server database, you can use report server management tools, (such as Report Manager and [SQL Server]SQL Server Management StudioManagement Studio), or programmatic interfaces such as URL access, Report Server Web service, or the Windows Management Instrumentation (WMI) provider.

報表伺服器資料庫的連接通常是透過 Reporting ServicesReporting Services 組態管理員定義。The connection to the report server database is usually defined through the Reporting ServicesReporting Services Configuration Manager. 但是,如果您選擇安裝預設組態,則可以在安裝過程中定義它。However, it can be defined during setup if you choose to install the default configuration. 如需報表伺服器連接到資料庫的詳細資訊,請參閱設定報表伺服器資料庫連線 (SSRS 設定管理員)For more information about the report server connection to the database, see Configure a Report Server Database Connection (SSRS Configuration Manager).

報表伺服器資料庫Report Server Database

報表伺服器資料庫是儲存下列內容的 [SQL Server]SQL Server 資料庫:The report server database is a [SQL Server]SQL Server database that stores the following content:

  • 報表伺服器所管理的項目 (.../ 報表與連結的報表、 共用的資料來源、 報表模型、 資料夾、 資源) 及其所有屬性和項目相關聯的安全性設定。Items managed by a report server (../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. 如需如何備份資料庫的建議和指示,請參閱將報表伺服器資料庫移至其他電腦 (SSRS 原生模式)For recommendations and instructions on how to back up the database, see Moving 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 are generated by the report server. 背景伺服器處理序將定期從暫存資料庫的資料表中移除較舊及未使用的項目。Background server processes will periodically remove older and unused items from the tables in the temporary database.

Reporting ServicesReporting Services 如果暫存資料庫遺失,不會重新建立暫存資料庫,也不會修復遺失或修改過的資料表。does not re-create the temporary database if it is missing, nor does it repair missing or modified tables. 雖然暫存資料庫並不包含永續性資料,不過您仍應備份該資料庫,以避免萬一需要執行失敗復原作業時還要重新建立。Although the temporary database does not 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 subsequently restore it, you should delete the contents. 一般而言,在任何時候刪除暫存資料庫內容都是安全的。Generally, it is safe to delete the contents of the temporary database at any time. 但是,您必須在刪除內容後重新啟動報表伺服器 Windows 服務。However, you must restart the Report Server Windows service after you delete the contents.

另請參閱See Also

在 SQL Server 容錯移轉叢集中裝載報表伺服器資料庫 Host a Report Server Database in a SQL Server Failover Cluster
儲存加密的報表伺服器資料 (SSRS 組態管理員) Store Encrypted Report Server Data (SSRS Configuration Manager)
Reporting Services Report Server Reporting Services Report Server
管理報表伺服器資料庫 (SSRS 原生模式) Administer a Report Server Database (SSRS Native Mode)
建立報表伺服器資料庫 (SSRS 組態管理員) Create a Report Server Database (SSRS Configuration Manager)
Reporting Services 的備份與還原作業Backup and Restore Operations for Reporting Services