I know what I did to mess up my reporting services, I just cant seem to figure out a repair. I made the mistake of pointing a test 2008 R2 reporting services at my production 2005 report server. I then could not pull up my reports on my old server, version
I then restored my ReportServer db from backup but was still getting an error. It looks like I should have been backing up my ReportServerTempDB. Now, when I try to run any of my reports, I get the following error:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Invalid object name 'ReportServerTempDB.dbo.PersistedStream'.
Any suggestions to what my options are? I still have my rdl's and could re-create the reportserver db if I have to and restore the individual reports. Just not sure where to go from here. Any help is much
View Complete Post