ConfigMgr 2007 R2 & R3 : How to back up SCCM 2007 SQL Reporting Services
A recent implementation at my ConfigMgr 2007 R3 TAP customer of R3 and SQL reporting services put me thinking ahead for our disaster recovery procedure .
SRS Reporting role needs to be installed in the DEFAULT Instance ! Named instances are not supported !!
The standard ConfigMgr 2007 backup task does not back up the SSRS reports or the SRS configuration.You need to take this into consideration if you :
- you have created any custom reports
- you have created any custom report models
- Set some custom security
- etc
I am not going to claim any credit for this , as I found one of my fellow MVP’s Steve Thompson ( in fact a great SRS report Guru ) has created an awesome blog post about it right here : http://myitforum.com/cs2/blogs/sthompson/archive/2009/06/16/how-to-back-up-sccm-2007-r2-reporting-services.aspx
Hope it Helps ,
Kenny Buntinx