Outcomes
- Full recovery in under one hour from initial contact.
- Database restored in 4 minutes and 35 seconds using Datamotive.
- Avoided the loss of over 13 hours of transactional activity that would have occurred from reverting to the midnight full backup.
- PITR policy updated to 2 checkpoints per hour, retained for 4 days, enhancing future recovery granularity.
Client Bio
A rapidly growing non-banking financial company (NBFC) in India, this lender operates in a compliance-heavy sector. Its KYC database supports customer onboarding, verification, and regulatory processes that directly impact turnaround times and customer experience.
Situation
During peak hours, several critical KYC tables were accidentally dropped. The team's last full backup was taken at midnight; Point-in-Time Recovery (PITR) checkpoints existed, but the exact time of the incident was uncertain, making recovery decisions more difficult.
Impact
Reverting to the midnight backup would have caused a loss of all activity since midnight - over 13 hours of customer onboarding and verification work - leading to significant operational, compliance, and potential revenue impacts during business hours.
Solution
Datamotive restored the clean 09:28 AM checkpoint in just 4 minutes and 35 seconds, ensuring data consistency. Validation of the 01:28 PM checkpoint further confirmed it was inconsistent. With Datamotive, the NBFC achieved full recovery in under an hour while maintaining business continuity.