SQL Server Performance

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

Discussion in 'SQL Server 2005 Reporting Services' started by GopalMynam, Jan 29, 2008.

  1. GopalMynam New Member

    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?
  2. satya Moderator

    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.
  3. GopalMynam New Member

    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.
  4. satya Moderator

    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.

Share This Page