Recovery Planning For SQL Reporting Services

  • Mike Pearson

    Default port

    Points: 1481

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/co

  • Dan Meacham

    Valued Member

    Points: 65

    Cool article - is it possible to implement a log shipping for the 2 Reporting Services databases, as a High Availablity story?

  • Jennifer-238881

    SSC Journeyman

    Points: 97

    Hello!

    This is a great article. Thanks for the info. My question for you; WHen I develop my reports in Visual Studio and deploy them, they are then saved to the ReportServer database.  Say I somehow lose my folder that contains all the VS projects for my reports and I need to recover my reports. Is there a way to extract them out of the database?  I don't know if I am phrasing this right so please ask questions.  I understand we can backup our file, I'm just wondering if there is away to extract the report definitions out of the database and back into Visual Studio.  Thanks!!

  • ramv-224884

    SSC-Addicted

    Points: 422

    This article is a life saver, helped us when our App server went down. Hats off to the author.

    Thanks!

  • SeeCoolGuy

    SSCrazy

    Points: 2871

    How did you loose your App server?

    I'm following the article for a server where a vendor removed IIS from the system... now I'm left scrambling... I did however notice that the system was still sending out scheduled reports 😐



    --
    Francisco

  • SeeCoolGuy

    SSCrazy

    Points: 2871

    After uninstalling the RS, and then re-installing, I am now getting this error after I try to restore my key...

    This edition of Reporting Services does not support web farm deployment. (rsInvalidRSEditionConfiguration)

    I didn't do anything diffrent... how did I miss this very important step?



    --
    Francisco

  • Dan B-304420

    SSC Enthusiast

    Points: 110

    had the same problem, but fixed it by deleting the rows from the keys table that referred to the old <InstallationID> using rskeymgmt -r <InstallationId>

  • Chris Hornung

    SSC Journeyman

    Points: 80

    Very useful article.  But the first defense is alway an image made by Ghost or Acronis etc. 

  • Paul Drumm

    SSC Enthusiast

    Points: 100

    I think another mentioned this. If you move the databases to a new server (not part of this problem) and you move the reporting services to a new server and you are not using the enterprise edition then you have to go into the keys database and remove one of the keys after you reactivate the system. In slq 2005 you can reactivate the system by adding the password, again, to the authentication in the reporting services config tool. I have to duplicate our production environment in QA and do this quite often.  I also back up the RS database everynight, along with the system databases. You can mirror these databases or put them on your cluster if you have one. Log shipping would work but it is not like you should be changing your production reports every 5 minutes.

  • Kathi Kellenberger

    SSChampion

    Points: 11811

    It is easy to get the report definition out.  Just go to the Report Services web page and navigate to the report you need.  Switch to the properties tab and choose "Edit". This will be an export of the rdl file.

    There might be a way to get the definition from the database, haven't tried that.

     

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • Sanjay Kaul

    Grasshopper

    Points: 19

    This is a great article! However, I could not make it work for when I have subscriptions for the reports. I am unable to edit the subscriptions after the restore on a different machine. Any ideas?

  • SimonLiew

    SSCertifiable

    Points: 7233

    I'm wondering how to backup the SSRS encryption keys from a remote server. As far as I know, rskeymgmt only works on the RS server itself.

    RSConfigTool.exe can connect remotely, but its a GUI based tool and doesnt work on command line.

    My company has quite a number of RS servers and its not easy to go into each RS server to backup the encryption keys. Is there anyway to automate the backup from a central location, etc?

    Simon

    Simon Liew
    Microsoft Certified Master: SQL Server 2008

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

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