Comment by ambicapter
10 hours ago
> we replicated the prod DB every morning
You may be storing logic in your database, but most businesses store data in their databases, and the amount of data they store (mostly because they can't tell what's important and what's not) makes copy-pasting their database every morning pretty unrealistic.
Some large telcos are doing it. Why would replicating a database daily be problematic?
Probably because you didn't account for that when architecting the system. Obviously it shouldn't be problematic but this is the real world full of poor technical decisions and mildly incompetent management that we're talking about here.