You are a database administrator for your company. The company uses a SQL Server 2005 computer that runs Reporting Services. Reporting Services is used to produce hundreds of reports each day. You discover that the ReportServerTempDB database is growing. You need to minimize the size of the ReportServerTempDB database. What should you do?()
- ADecrease the time between transaction log backups of the database.
- BDelete report snapshot history each week.
- CMinimize the use of session caching in the reports.
- DMinimize the use of report snapshots in the reports.