undefined | Better HN

0 pointsmichaelt4y ago0 comments

> I was convinced that incomplete or unreliable backups were a total waste of time and money. (Which tbf isn't 100% false.)

It depends a lot on your use case.

If you're backing up a production database system that's in constant use, then the files are almost certain to change while the backup is in progress. And a backup of everything on the database server except the data probably isn't what you want!

On the other hand, if I'm backing up my personal computer, my family photos aren't getting regularly overwritten - and if the backup of my web browser cache is inconsistent? So be it.

0 comments

4 comments · 2 top-level

aidenn04y ago· 2 in thread

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.

professoretc4y ago

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.

aidenn04y ago

I think with Oracle you needed to replay the archive log; not sure if that was via rman or just a mount option.

Either way it was identical to crash recovery

drewzero14y ago

In my case it was mostly office PCs that might have important documents or spreadsheets on them. I've been working on a redundant, networked backup solution to serve the whole office, but realized that I was building a henhouse while the chickens were already running loose. So I ordered some USB hard drives just to make sure things were getting copied.

Maintaining a super basic (but regularly verified) hourly incremental backup system has spared the people who use those PCs a lot of grief, plus saved me time trying to recover lost data.

j / k navigate · click thread line to collapse