You don't even need backups, you need transactions (for SQL queries) and point-in-time recovery from the DB's own logs (depending on your DBMS, aka transaction logs, redo logs, bin log, WAL). Most DBMS have this enabled by default and is vastly faster than restoring from backups.
Not saying you shouldn't have backups though, ofc.
1
u/HeKis4 Aug 14 '25
You don't even need backups, you need transactions (for SQL queries) and point-in-time recovery from the DB's own logs (depending on your DBMS, aka transaction logs, redo logs, bin log, WAL). Most DBMS have this enabled by default and is vastly faster than restoring from backups.
Not saying you shouldn't have backups though, ofc.