Post reply

Restoring Reporting Services 2005

  • August 17, 2010 at 6:51 am

    #142360

    I'm planning for a disaster recovery scenario where our SQL Server 2005 Report Server crashes and I need to restore from the backup ReportServer and ReportServerTempDB files to a different server.

    1. Does the ReportServer database contain the report definitions (rdl), report history and subscriptions?

    2. Is a recovery as simple as restoring the ReportServer and ReportServerTempDB databases and encryption keys to a new server?

  • August 17, 2010 at 1:29 pm

    #1208105

    Patrick Womack (8/17/2010)

    I'm planning for a disaster recovery scenario where our SQL Server 2005 Report Server crashes and I need to restore from the backup ReportServer and ReportServerTempDB files to a different server.

    1. Does the ReportServer database contain the report definitions (rdl), report history and subscriptions?

    2. Is a recovery as simple as restoring the ReportServer and ReportServerTempDB databases and encryption keys to a new server?

    here are some wonderful articles about DR for Reporting Services which I've used in the past:

    http://sqlcat.com/technicalnotes/archive/2009/10/23/sql-server-reporting-services-disaster-recovery-case-study.aspx

    http://www.sqlwebpedia.com/content/how-move-reporting-services-new-server

    Alex S

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply