I am wanting to check that we are backing up sufficient data to restore SQL and have been able to locate most information except for Snapshot Reports. I have located a table in ReportServer\Tables\Snapshotdata but it does not appear to have enough data for the reports we have.
Where would the physical data normally be stored for the snapshot reports that have been created in Report Manager
It's in a few tables - Snapshot, ChunkData and SegmentedChunk
And then you have the related ChunkSegmentMapping, History, Segments and there are also references to the Report itself which would be in the Catalog table.
But that really doesn't matter in terms of restoring SQL Server Reporting Services.
To restore Reporting Services, you should be backing up the ReportServer and ReportServerTempDB databases.
Sue
And I missed the title - the history is in the history table. Bits and pieces aren't going to be of much use though.
I know a fair amount about the tables and really can't figure out what you are trying to do. The databases for SSRS aren't normal relational databases.
Sue