Hi,
Is there a way to back up the snapshot history of a specific report? I'm thinking on an operations perspective where we need to back up snapshot histories and restore them in case something happens on a production environment. Also, I'm thinking of saving only for specific reports and not for all reports in the same environment/server.
Thanks.
There isn't a supported way. You can get innovative by archiving tables Snapshot, History, and ChunkData in the ReportServer database (see CopyExecutionSnapshot stored procedure) but a future service pack may break your implementation if the schema changes.
|||Thanks Teo. But I can't seem to search any documentation on CopyExecutionSnapshot in SQL Server Books Online or MSDN. Would you be able to point me to the right place?
|||It is a stored procedure in the Report Catalog and no, you won't find the Report Server database documented. Use it at your own risk.
No comments:
Post a Comment