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.

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.


Originally published at https://parvtheitgeek.com on January 19, 2014.

Published by Parvinder Nijjar

I blog at ParvTheITGeek.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

<span>%d</span> bloggers like this: