SSRS – Archiving snapshots and retriving as and when needed for viewing | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SSRS – Archiving snapshots and retriving as and when needed for viewing

I have a requirement in SSRS.
The customer wants to have snapshots generated at regular intervals and be available for 14 days on line. After 14 days the snapshots are to be archived to a secondary location for 37 days. After 37 days, the reports are to be moved to final storage.
The user should be able to retrive report(s) for viewing into on-line form secondary location.
The user should able be able to retrive the report(s) from final storage into on-line for viewing.
Is there a way to implement this feature with SSRS? If not is there any other reporting system that can do this?

Do you want snapshot of backups or reports?
FOr data snapshot you could take help of snapshot backups, where you need to have enterprise edition for SQL to take such an advantage.

Hi Satya,
Snapshots are generated one for every day. The cusromer does not want to delete the snapshots and also limit them to 8 days on line.
I need to backup (archive) the snapshots that were generated into a secondary storage and retrive as and when required for on-line viewing.

Having the Enterprise edition of SQL you could schedule such snapshot backups and similar to archiving to those snapshots in order to keep them for customer viewing.


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |