History Snapshot Reports - Where are they stored?

  • 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

  • les.61 - Wednesday, March 21, 2018 10:12 PM

    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

  • Sue_H - Thursday, March 22, 2018 3:08 PM

    les.61 - Wednesday, March 21, 2018 10:12 PM

    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

  • Sue

    Many thanks. We are backing up both the ReportServer and ReportServerTempDB so based on your information I am happy that we are backing up the reports.

    Many thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply