Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Recovery Planning For SQL Reporting Services Expand / Collapse
Author
Message
Posted Friday, December 31, 2004 12:29 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 4, 2007 4:36 AM
Points: 27, Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/co


Post #153177
Posted Friday, July 1, 2005 7:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 20, 2008 8:49 AM
Points: 5, Visits: 11
Cool article - is it possible to implement a log shipping for the 2 Reporting Services databases, as a High Availablity story?
Post #196298
Posted Friday, August 26, 2005 5:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 6, 2006 10:31 AM
Points: 1, Visits: 1

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!!

Post #214642
Posted Friday, September 16, 2005 10:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:40 PM
Points: 10, Visits: 212

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

Thanks!

Post #220755
Posted Wednesday, October 5, 2005 11:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:59 PM
Points: 180, Visits: 104
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
Post #226333
Posted Wednesday, October 5, 2005 1:22 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:59 PM
Points: 180, Visits: 104
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
Post #226377
Posted Wednesday, February 22, 2006 10:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 22, 2006 2:25 PM
Points: 4, Visits: 1
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>
Post #260691
Posted Friday, February 16, 2007 7:40 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 28, 2008 10:08 PM
Points: 20, Visits: 23

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

Post #345478
Posted Friday, February 16, 2007 9:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 24, 2014 3:36 PM
Points: 4, Visits: 202
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.
Post #345528
Posted Friday, February 16, 2007 11:11 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 8:25 AM
Points: 769, Visits: 251

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
Microsoft
(Former SQL Server MVP)
Post #345554
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse