Recovery Planning For SQL Reporting Services

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Mike Pearon » Recovery Planning For SQL Reporting Services

12 posts, Page 1 of 2

1 2 »»

Recovery Planning For SQL Reporting Services

Rate Topic

Display Mode

Topic Options

Author

Message

Mike Pearson

Posted Friday, December 31, 2004 12:29 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 04, 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

Dan Meacham

Posted Friday, July 01, 2005 7:29 AM

Forum 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

Jennifer-238881

Posted Friday, August 26, 2005 5:00 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 06, 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

ramv-224884

Posted Friday, September 16, 2005 10:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 2:07 PM
Points: 9, Visits: 209

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

Thanks!

Post #220755

Francisco-35089

Posted Wednesday, October 05, 2005 11:55 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 11, 2013 10:32 AM
Points: 169, Visits: 98

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

Francisco-35089

Posted Wednesday, October 05, 2005 1:22 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 11, 2013 10:32 AM
Points: 169, Visits: 98

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

Dan B-304420

Posted Wednesday, February 22, 2006 10:29 AM

Forum 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

Chris Hornung

Posted Friday, February 16, 2007 7:40 AM

Grasshopper

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

Paul Drumm

Posted Friday, February 16, 2007 9:14 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 9:38 AM
Points: 4, Visits: 197

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

Kathi Kellenberger

Posted Friday, February 16, 2007 11:11 AM

Right there with Babe

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 6:45 AM
Points: 769, Visits: 213

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 »

12 posts, Page 1 of 2

1 2 »»

Permissions