What should you do?

You are a database administrator for AIOTestKing.com. 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?

You are a database administrator for AIOTestKing.com. 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?

A.
Minimize the use of report snapshots in the reports.

B.
Decrease the time between transaction log backups of the database.

C.
Delete report snapshot history each week.

D.
Minimize the use of session caching in the reports.



Leave a Reply 0

Your email address will not be published. Required fields are marked *