reports on report manager

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  October 26, 2010 at 10:52 am

  #228433

  I i lost all my reports on report manager can i get them back from the ReportServer database for which i have a backup?

• Iulian -207023

  SSCertifiable

  Points: 7639

  More actions

  October 27, 2010 at 2:35 am

  #1242710

  Hi, Did you tried to restore the database from the backup?

  Regards,

  Iulian

• Rich Mechaber

  SSChampion

  Points: 11130

  More actions

  October 28, 2010 at 6:57 am

  #1243506

  Found this w/ Google:

  http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/c5442c34-3160-4084-bfc3-ac64e71aa907

  HTH,

  Rich

• Dave Klug

  SSCertifiable

  Points: 5811

  More actions

  October 30, 2010 at 5:36 am

  #1244516

  Yes, you can restore the ReportServer from a DB backup. The only issue you may run into is regarding the encryption key of the RS. Do you have a backup?

  1) Stop the ReportServer service

  2) Restore the Report Server DB from backup

  3) Restore the Encryption Key or If you you're missing the encryption key, using the Reporting Services Configuration Manager, go to Encryption Keys and delete the encrypted content.

  4) Start the ReportServer service

  If you needed to delete the encryption key, you will need to go through your data sources and reenter and saved passwords you have.