September 20, 2011 at 10:03 am
Our production ssrs creates snapshots daily, which the users view under report history. Last Friday I accidentally deleted one of the reports, instead of overwriting it with an update - so the history is lost. I have a database backup, but since we didn't notice the problem right away, I don't want to restore the backup of ReportServer, or else everything since Friday would be lost. So I'm trying to create some SQL to copy the snapshots from a restored database into ReportServer. Does anyone know if this is possible?
Doing some work in my test environment, I thought I had valid queries to get the appropriate Catalog, History, SnapShotData, SegmentChunkMapping and Segment records out of the backup into ReportServer - but so far no luck. It seems when the report is deleted, it doesn't always clean up all of these tables. Even when I try to manually delete everything, and then copy back over - I can see the history record, once it even let me view the report - but mostly I just get an 'Internal Error' when I try to view it.
Any idea if what i'm trying to do is possible, and if so, what I'm doing wrong? thanks.
September 20, 2011 at 11:07 am
Not sure if it matters, but I did truncate all of the tables in ReportServerTempDB, in case they were conflicting with records I added back into ReportServer.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply