Report Server Database Documentation RRS feed

  • Question

  • Hail to all the serious Report Server users. Let us all start the documentation effort on Report Server Database (Reporting Services 2005). This will let us work around many problems that occur due to lask of documentation of the RS DB Schema. 


    Example :    

    1. Subscriptions table in the report server database can be used for handling the subscriptions manually. A DML statement coupled with the same on the sysjobs in msdb database can stop corrupt subscriptions (which cannot be modified directly using User Interfaces)

    Current Problem

    1. The problem that I am facing is related to the size of the Report Server (it is above 35 GBs, with 422 users) while its counter part with 128 users is only 4 GBs. This  is due to a table ServerParametersInstance which is growing in an out-of-bound fashion. The lack of documentation is hurting.


    So let us put in some effort & document the RS Database for good.


    Any help is greatly appreciated...

    Tuesday, May 8, 2007 8:09 AM