Home > SSRS > Automation of Report Snapshot : Snapshot Export, Delete Snapshot

Automation of Report Snapshot : Snapshot Export, Delete Snapshot

Snapshots are created and stored as part of SSRS report execution feature, we can manually created the snapshot or else we can schedule it. We can set limit the snapshots generated as unlimited. In due course the number of snapshots increased and degrade the performance of reportserver.

Recently I got the issue of performance of reportserver due to this, and we all decided to generate the output of each snapshot and export into Excel and delete that particular snapshot whose output is saved. We have 9 months daily snapshots for each report and reports are more than 500, hence this task cant be done manually.

This POC done by us to how we can see all the snapshots releated to particular report and export all snapshots output into shared drive and finally delete the report snapshots.

To know more on this topic please visit to website http://msbitips.com.

Directly to this topic: Automation of Report Snapshot : Snapshot Export, Delete Snapshot

 

Thanks
Prasad

Learn Different BI Tools
Subscribe my YouTube Channel : BI Tools

Advertisements
Categories: SSRS Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: