Testing log Retention

nabeelaslam1994 — Mon, 20 Feb 2023 15:53:43 GMT

Hello Team,

I had a DBA from source endpoint that increased the log retention time from 24 hrs. to 72 hours and he requested to confirm a UAT to see the changes looks good on the Replicate side? Is there a way to TEST the log retention changes?

source: SQL Server, PostgreSQL

Thanks,

Nabeel

Re: Testing log Retention

john_wang — Tue, 21 Feb 2023 10:21:42 GMT

Hello @nabeelaslam1994 ,

If I understood correctly, you are meaning the transaction log retention. is that correct?

if yes, then you may try to startup a CDC ONLY task by timestamp, or LSN in SQL Server, POS in PostgreSQL, to see if you get 3 days ago data changes. Cetainly it's better to set target with 'Store Change' mode.

Please take note the slot in PostgreSQL should be created in 3 days ago, by Replicate, or manually.

Hope this helps.

Regards,

John.

topic Testing log Retention in Qlik Replicate

Testing log Retention

Re: Testing log Retention