I'm looking for some insight on Reporting Services 2008. I currently am backing up the ReportServer Database and loading it weekly to our DRP site (we don't make many changes). While I fully understand that I could mirror this database, I have now decide to have this DRP Server to run off of the DRP data 'Sources'. Is there a way that when changes are made to reports that I can have them copied to the DRP site without having to manually upload the RDL files every time a change is made? If not then this just doesn't make any sense to me.
Thanks in advance for your expertise!