Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
ReportServer & ReportServerTempdb databases - how to perform maintenance on these databases?

YOu may be aware that when you deploy the Reporting Services it uses two SQL Server relational databases for internal storage. By default, the databases are named ReportServer and ReportServerTempdb. They are classed as system databases for Reporting Services, ReportServerTempdb is created with the primary report server database and is used to store temporary data, session information, and cached reports. In this case you have to perform maintenance for these databases within your environment too, and database administration tasks include backing up and restoring the report server databases and managing the encryption keys that are used to encrypt and decrypt sensitive data.

You will not be able to perform index rebuild for these databases, by default the recovery model will be in SIMPLE. SO as long as you manage backup it will be ok, being a system database not required to perform frequent maintenance.

Posted: Thursday, July 05, 2007 9:22 AM by SQL Master

Comments

SSQA - SqlServer-QA.net said:

YOu may be aware that when you deploy the Reporting Services it uses two SQL Server relational databases

# July 5, 2007 10:45 AM
Anonymous comments are disabled