Home Forums SQL Server 2008 T-SQL (SS2K8) Change Tracking CHANGE_RETENTION = 1 DAYS RE: Change Tracking CHANGE_RETENTION = 1 DAYS

  • October 13, 2017 at 2:17 pm

    #1963646

    RVO - Friday, October 13, 2017 12:43 PM

    I changed it to 1 DAY
    but all tracking data seems to stay there and keeps accumulating . . .
    I expected a cleanup....?

    Give it a bit and see. From what I remember, one day deleted anywhere between 24 and 48 hours.
    That's what I was alluding to in my earlier post.

    Sue