SQL Server Performance

Reporting Services backup(Reports/Rdls)

Discussion in 'ALL SQL SERVER QUESTIONS' started by gshyam23, Sep 26, 2013.

  1. gshyam23 New Member

    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.
  2. Shehap MVP, MCTS, MCITP SQL Server

    Sure , you can use this simple tool RS scripter tool to upload any single report folder , single .rdl or even single .rds from a report server to another report server with no longer need to backup the entire of reportserver DBs from a server to another server thereby I am using it often in my work , you can learn more about it at http://jpedroalmeida.wordpress.com/...-tool-to-help-you-migrate-reporting-services/

    Please let me know if any further help is needed

Share This Page