Re:Correct Backups Require Filesystem Snapshots
by aidenn0 on Monday May 16, 2022 @04:03PM
(#31402556)
It's been a while, but with e.g. Oracle 10, it was specifically stated in the docs that backing up the data-file(s), followed by the archive-logs, you would end up with a recoverable backup. I'm not sure if other databases are designed that way.
[ Parent
| on HN ]
Re:Correct Backups Require Filesystem Snapshots
by professoretc on Monday May 16, 2022 @07:07PM
(#31404129)
I've done it with SQL Server, but it wasn't automatic. I had to manually repair or remove the DB pages that were in use when the backup was made.