SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Recovery Planning For SQL Reporting Services


Recovery Planning For SQL Reporting Services

Author
Message
Mike Pearson
Mike Pearson
SSC-Enthusiastic
SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)

Group: General Forum Members
Points: 167 Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/co



Dan Meacham
Dan Meacham
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 11
Cool article - is it possible to implement a log shipping for the 2 Reporting Services databases, as a High Availablity story?
Jennifer-238881
Jennifer-238881
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 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!!


ramv-224884
ramv-224884
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 237

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

Thanks!


Francisco-35089
Francisco-35089
Old Hand
Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)

Group: General Forum Members
Points: 372 Visits: 128
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
Francisco-35089
Francisco-35089
Old Hand
Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)

Group: General Forum Members
Points: 372 Visits: 128
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
Dan B-304420
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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>
Chris Hornung
Chris Hornung
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 23

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


Paul Drumm
Paul Drumm
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 206
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
Kathi Kellenberger
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1465 Visits: 344

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
Linchpin People Teammate
SQL Server MVP
Author of Expert T-SQL Window Functions
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search