none
increase history snapshot retention in ssrs 2016 RRS feed

  • Question

  • Is there anyway we can increase history snapshot retention in ssrs 2016 to 6 months or 1 year
    Tuesday, June 25, 2019 8:58 PM

Answers

  • Hi Sam Har

    According to your description , you could try to limit the snapshot number based on the schedule .

    (suppose ,one day execute once , then one year is 365 )

    Or you could try to add one sql agent job to remove the correspond snapshot in correspond tables

    (History ,Catalog, SnapshotData) in report server database ,run the sql agent job every day and check it to remove the outdate records.

    Hope it can help you.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    • Proposed as answer by Eric Liu001 Thursday, June 27, 2019 5:33 AM
    • Marked as answer by Sam Har Thursday, June 27, 2019 2:01 PM
    Wednesday, June 26, 2019 1:39 AM

All replies

  • Try this link:

    https://docs.microsoft.com/en-us/sql/reporting-services/reports/limit-report-history-report-manager

    • Proposed as answer by Eric Liu001 Thursday, June 27, 2019 5:33 AM
    • Unproposed as answer by Sam Har Thursday, June 27, 2019 2:01 PM
    Tuesday, June 25, 2019 10:21 PM
  • Hi Sam Har

    According to your description , you could try to limit the snapshot number based on the schedule .

    (suppose ,one day execute once , then one year is 365 )

    Or you could try to add one sql agent job to remove the correspond snapshot in correspond tables

    (History ,Catalog, SnapshotData) in report server database ,run the sql agent job every day and check it to remove the outdate records.

    Hope it can help you.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    • Proposed as answer by Eric Liu001 Thursday, June 27, 2019 5:33 AM
    • Marked as answer by Sam Har Thursday, June 27, 2019 2:01 PM
    Wednesday, June 26, 2019 1:39 AM