SQL Server Performance

Reporting Services

Discussion in 'SQL Server 2005 Reporting Services' started by najeed_dba, Jun 6, 2007.

  1. najeed_dba New Member

    Hi all,

    If we restore the backup of ReportServer and ReportServerTempdb databases ( and other database which reports are accessing) from primary server to the Secondary server, then after restoring these bak file, do we get all the readymade reports on the report manager (or) do we have to do anything else.

    And if in above case, if we dont get the backup of Encryption key ( Reporting services configuation), then what should be my approach.

    Thanks.

    Najeed.
  2. satya Moderator

    Moving a database has no effect on scheduled operations that are currently defined for report server items. Schedules will be recreated the first time you restart the Report Server Windows service. Subscriptions, cached reports, and snapshots are preserved in the moved database. Temporary report and user session data that is stored in reportservertempdb will be persisted when you move that database.

    Look at thishttp://technet.microsoft.com/en-us/library/ms156274.aspx for keys.

    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. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page