SQL Server Performance

Can we have transactional replication on SSRS DBs

Discussion in 'SQL Server 2005 Replication' started by ehsan, May 1, 2007.

  1. ehsan New Member

    Guys,

    I have simple question, Can we create a tranactional (or any sort of) replication on SSRS databases. i.e. ReportServer, ReportServerTempDB.

    ReportServerTempDB is a temporary database like tempdb?



    Ehsan
  2. ndinakar Member

    I dont see why not. Perhaps someome can correct me if I am wrong.

    ***********************
    Dinakar Nethi
    SQL Server MVP
    ***********************
    http://weblogs.sqlteam.com/dinakar/
  3. ehsan New Member

    I had created transactional replication, but it was messging the configuration on the target server. Then I had restored ReportServer from the old backup and it was just fine.



    Ehsan
  4. MohammedU New Member

    I don't think create replication on report server databses specially ReportServerTempDB database....

    From BOL...

    Renaming a report server database is not supported because the report server databases are considered internal components.

    I believe it replication will not work on thsese dbs...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  5. satya Moderator

    Why do you want to create replication for these database, do you have any specific reason?
    BOL specifies:
    Reporting Services deployment uses two SQL Server relational databases for internal storage. By default, the databases are named ReportServer and ReportServerTempdb. ReportServerTempdb is created with the primary report server database and is used to store temporary data, session information, and cached reports


    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  6. ehsan New Member

    Satya,

    I am using SQL server 2005. I am using Visual Studio Team Foundation server for .rdl deployment.

    We want to replicate the .rdls files and connections from one server to the other. Instead of manually deploye these reports and connections, we thought about replication. I tried transactional replication and then figured out that ReportServer and ReportServerTempDB is kind of other system databases (Master, Model, MSDB, TempDB) in nature.

    Please tell me is there any way that my .rdls (report files) and connections for SSRS can be replicated to my 2nd server from server no. 1?

    Thanks,

    Ehsan

Share This Page