Reporting Services Maintenance

• DBAgal

  Hall of Fame

  Points: 3185

  More actions

  July 21, 2010 at 9:10 am

  #223516

  Hi all -

  I'm building a maintenance plan for a new Reporting Services instance. In the past, I have always included backing up the config files, never the encryption key. Different articles say different things about backup procedures.

  I just wanted some opinions on what should be backed up concerning Reporting Services, in addition to the ReportingServer and the ReportServerTempDb?

  Thanks in advance.

• Andy Hogg

  SSCarpal Tunnel

  Points: 4585

  More actions

  July 23, 2010 at 3:33 pm

  #1197803

  Would have thought you would be covered if you were to back up:-

  1) Both databases.

  2) Encryption key (although obviously this won't change unless you generate a new one).

  3) Config files, especially rsreportserver.config

  4) Certificate file if you are using SSL.