Post reply

Reporting Services backup(Reports/Rdls)

  • September 26, 2013 at 7:11 pm

    #280292

    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.

  • September 26, 2013 at 10:25 pm

    #1653844

    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.

  • September 27, 2013 at 12:20 am

    #1653863

    Another option is to use source control on your development environment.

    For example TFS integrated in BIDS.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 27, 2013 at 8:09 am

    #1654042

    Thanks for your inputs

Viewing 4 posts - 1 through 3 (of 3 total)

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