- 1 minutes to read
What retention policies should I use for different message types?
Configure per-type based on compliance requirements:
- Financial transactions (ACH payments, wire transfers, credit cards): 7 years (SOX/PCI-DSS mandatory)
- Healthcare HL7 (patient admissions, lab results, prescriptions): 10 years (HIPAA medical records retention)
- Customer orders (e-commerce, B2B): 3-5 years (warranty/returns support, tax audits)
- Debug/development logs: 30-90 days (troubleshooting recent issues only)
- Audit trails (user actions, configuration changes): 7-10 years (compliance investigations)
Cost optimization: Shorter retention = lower SQL Server storage costs. Archive old events to cheap blob storage (Azure Blob $0.002/GB/month, AWS S3 Glacier $0.001/GB/month) if regulatory requirements mandate longer retention but searchability not required after N years.
Related Questions
See all FAQs: [Troubleshooting Overview][]