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

Reporting Services backup(Reports/Rdls) Expand / Collapse
Author
Message
Posted Thursday, September 26, 2013 7:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 1:23 PM
Points: 5, Visits: 95
Guys,

Any body worked on backing up reports from Report Manager for any DR purpose?

I hope taking the backup of ReportServer DB will have the reports but if we want to recover we need to restore complete database which will over write all the reports.

is there any way we can backup just reports so that we can recover specific report which is required.

Please help me if any one came across this.

Thanks,
-Shyam.
Post #1499133
Posted Thursday, September 26, 2013 10:25 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:00 AM
Points: 2,993, Visits: 2,590
Out of the box, Microsoft include a tool that you can use to do this - "RS.Exe". You can find this is folder "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn" - or similar depending on the SQL version and hardware you install on. This utility can be used to script most actions that are supported by reporting services. You may need to write a little VB code to go with it to actually tell it what to do.

There is another tool out there called "RS Scripter". It has become a little difficult to find of late - the site it was on no longer exists. If you can find it, it give you a graphical interface to guide and you should be able to get it to script reports out to files.



Post #1499170
Posted Friday, September 27, 2013 12:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:37 AM
Points: 13,735, Visits: 10,707
Another option is to use source control on your development environment.
For example TFS integrated in BIDS.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1499199
Posted Friday, September 27, 2013 8:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 1:23 PM
Points: 5, Visits: 95
Thanks for your inputs
Post #1499406
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse