restore Report server databases
What will happen If we restore SSRS databases i.e. ReportServer and ReportServertempdb from a backup of another SSRS databases?
Cheers Sunil Gure
March 22nd, 2011 9:15am
Do you have the encryption key? For 2005 you would have to go through Report Server Configuration manager and set it back up to use. If you do not have the encryption key, then all datasources will be gone and subscription information will
also be lost.
Free Windows Admin Tool Kit Click here and download it now
May 5th, 2011 4:56pm
What will happen If we restore SSRS databases i.e. ReportServer and ReportServertempdb from a backup of another SSRS databases?
Cheers Sunil Gure
To answer your question, all the content(users, reports, security, subscriptions etc) in your existing server will be replaced by the information you have in the database you are restoring from. Hope that helps.
May 5th, 2011 5:11pm