Don't have a specific method for you except to ask why would want to do this regularly? The reporting services DB stores reporting services specific data like reports and subscriptions. Unless you are changing these regularly, there's no need to back up the DB. Once after you make changes is sufficient as the DB does *not* store ConfigMgr data.
J From: [email protected] [mailto:[email protected]] On Behalf Of Roland Janus Sent: Tuesday, February 24, 2015 2:22 AM To: [email protected] Subject: [mssms] Reporting service backup, automated Anyone has that automated? I have the DB backup running (from ola.hallengren.com), but then there is the encryption key and the files. Am I right, as long as the reporting services isn't reconfigured, backing up the encryption key once is sufficient? But those still need to be done regularly, right? * Rsreportserver.config * Rssvrpolicy.config * Rsmgrpolicy.config * Reportingservicesservice.exe.config * Web.config for both the Report Server and Report Manager ASP.NET applications * Machine.config for ASP.NET I'm thinking of adding this to the DB backup tasks, but maybe someone has already a solution for that? We may use Veeam in the future, would this be able to do all that? -R
