Reporting Services

SQL Server Reporting Services 2008 (SSRS) Databases- ReportServer & ReportServerTempDB.

When reporting service is set up there are two default databases created which are

1. ReportServer

2. ReportServerTempDB.

1

Reportserver database contains a wide range of information which is briefly listed below.

1. Subscriptions

2. Schedules

3. Data sources

4. Folder

5. Keys

6. History

7. Notifications and much much more.

I would suggest looking at the tables which are contained in the ReportServer database to get a good understanding about all the data which is stored and within and I have listed below.

ActiveSubscriptions

Batch

CachePolicy

Catalog

ChunkData

ChunkSegmentMapping

ConfigurationInfo

DataSets

DataSource

DBUpgradeHistory

Event

ExecutionLogStorage

History

Keys

ModelDrill

ModelItemPolicy

ModelPerspective

Notifications

Policies

PolicyUserRole

ReportSchedule

Roles

RunningJobs

Schedule

SecData

Segment

SegmentedChunk

ServerParametersInstance

ServerUpgradeHistory

SnapshotData

Subscriptions

SubscriptionsBeingDeleted

UpgradeInfo

Users

I would always recommend setting a maintenance plan to regularly backup this database due to all the important data that is held within. Do not attempt to try and modify the table structure within these tables as you will likely cause an error.

ReportServerTempDB stores temporary data from the ReportServer DB which includes cached reports, session information….. This data is still important and it should still be backed up to aid speedy recovery.

Leave a Reply