SSRS Tutorial Part 128 - Reporting Services Databases ( ReportServer and ReportServerTempDB)

In this video of SSRS Tutorial, we will learn about ReportServer and ReportServerTempDB.

We will learn below items in this video

ReportServer Database:

ReportServer is the database which is used to store Metadata and Definition of Objects used by Reporting Server.

ReportServer TempDB:

ReportServerTemp DB is created with ReportServer Database.It stores temporary data, session information, and cached reports.

ReportServer Database Objects:

dbo.Catalog:

This table contains information related to Home,Folders,Sub Folders, Reports,Data Sets,Data Sources, Report Definition(XML) as content column

Select * from dbo.Catalog

Dbo.DataSource:

This table stored all the Data Sources embedded or shared.

  Select * From dbo.DataSource

Dbo.DataSets:

It stores list of shared data sets.

Select * From dbo.DataSet

Dbo.Subscription:

This table stored the information related to Subscription such as Description,LastStatus,EventType,Parameters and deliveryExtension

Select * From dbo.Subscription

Dbo.Schedule:

This table contains information for schedules on which the subscriptions are scheduled.

Introduction to SSRS Databases ( ReportServer and ReportServerTempDB) - SQL Server Reporting Services (SSRS) Tutorial