March 21, 2018 at 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
March 22, 2018 at 3:08 pm
les.61 - Wednesday, March 21, 2018 10:12 PMI 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
March 22, 2018 at 3:24 pm
Sue_H - Thursday, March 22, 2018 3:08 PMles.61 - Wednesday, March 21, 2018 10:12 PMI 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
March 22, 2018 at 4:27 pm
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