Data Archival by region
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-08-2025 03:16 AM
Hi all,
I have a customer who operates in multiple geographic locations and is looking to archive data based on different geographies and different archival rules. The scenario is as follows:
- Country 1 - must only have 5 years online data with all other items archived
- Country 2 - must retain 7 years online data with all other items archived
The instance does not use domain separation.
Does anyone have any suggestions or best practices on how to approach this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-08-2025 03:19 AM
Does your transactional data have some sort of indication to know which region it belongs to (location field being used?)
You can define multiple archive rules per table, so your use case is possible. You'd need to ensure they don't overlap, and records that meet either criteria are also reviewed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2025 01:38 AM
The data will have a location field that can be used. We will be using the incident table as a start and have incidents that are related to region 1 archived separately to region 2 (2 archive tables?)
Is this possible?
