I typically recommend just rebuilding the SUSDB. There's absolutely nothing unique about it. Backing it up is easy to add to your SQL maintenance plan though - you are using a native SQL backup up now for 2012, correct?
As for SSRS, same thing really. The reports are stored in the SSRS DB so backing it up is sufficient including the encryption key. You can also individually export the RDL files via the SSRS web portal (http://sql-articles.com/articles/general/download-export-rdl-files-from-report-server/), using report builder or a handful of third-party tools. Note that you only need to back up the encryption key once, ever, and reports only need to be backed up when you change them. J From: [email protected] [mailto:[email protected]] On Behalf Of Keith Valenca Sent: Thursday, August 29, 2013 7:47 PM To: [email protected] Subject: [mssms] Backup Restore SSRS/SUSDB I've searched the web, looked at blogs and I can't for the life of me figure out the following: I have SCCM2012 SP1 Primary with remote SQL and remote SSRS, with lots of custom reports. I read you need to backup the encryption key and also the .rdl files for SSRS, but it seems to be some manual process or I just don't understand how to do it. What is the process to backup SSRS so if the machine blows up I can restore it using the same machine name and have my primary still be able to access the reports without losing them all? I have the same sort of question for SUSDB. Do you backup and then restore that if your site blows up or just let it get re-created when you reinstall the site? I have the SUSDB on my remote SQL server. Thanks Keith
