Can Continuous Backup in Cosmos DB Restore Items Expired by Time to Live (TTL)?

Khushaal Kurswani 40 Microsoft Vendor

Can Cosmos DB's continuous backup feature restore items deleted by Time to Live expiration

In the periodic backup documentation, it clearly states that documents that were deleted because of expired TTL will not be restored. But no such limitation is stated in the continuous backup documentation.

So, I just wanted to confirm if it is possible to restore documents deleted by Time to Live using continuous backup.

NIKHILA NETHIKUNTA 3,505 Reputation points Microsoft Vendor

2024-11-14T08:49:05.7833333+00:00

@Khushaal Kurswani
Thank you for the question and for using Microsoft Q&A platform.
We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.
Khushaal Kurswani 40 Reputation points Microsoft Vendor

2024-11-15T23:00:28.9666667+00:00

Hi @NIKHILA NETHIKUNTA Thank you for responding! Have you received a response from the internal team?
ShaktiSingh-MSFT 15,766 Reputation points

2024-11-18T04:27:26.3166667+00:00

Hi @Khushaal Kurswani ,

Thanks for your patience.

Response is still awaited from internal team.

1 answer

ShaktiSingh-MSFT 15,766 Reputation points

2024-11-18T07:54:30.37+00:00

Hi @Khushaal Kurswani ,

Below is the reply from the internal team:

In Continuous Backup, the default restore process restores all the properties of a container including its TTL configuration by default, this can result in deletion of data if restore is done without way to disable the TTL. To prevent the deletion please pass parameter to disable TTL in PowerShell (-DisableTtl $true) or cli (--disable-ttl True) while doing the restore.

Hope this helps.

Thanks
Please sign in to rate this answer.
Khushaal Kurswani 40 Reputation points Microsoft Vendor

2024-11-18T17:57:04.8766667+00:00

Thank for the response but perhaps I did not phrase the question correctly.

I understand that the restoring the backup will also restore the original TTL configuration.

However, I am trying to confirm if it is possible to restore documents deleted by Time to Live using continuous backup.

Suppose I have TTL enabled for a Cosmos DB container, and it deletes records older than a week. In addition, I have continuous backup enabled for the Cosmos DB which is continuously storing backups for the database. If I restore a backup from 10 days ago, will it restore the records that were deleted by the TTL policy since that backup was created 10 days ago?

ShaktiSingh-MSFT 15,766 Reputation points

2024-11-19T01:57:12.36+00:00

Hi @Khushaal Kurswani ,

Please raise support case for your usecase is what is suggested by the internal team.

Thanks
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Can Continuous Backup in Cosmos DB Restore Items Expired by Time to Live (TTL)?

1 answer

Your answer