3 ms·
> You still have to back the files up, regardless of where you put them. If they are actual files you can do an incremental backup. If they are in the database
by ars 15y ago
> You still have to back the files up, regardless of where you put them.
If they are actual files you can do an incremental backup. If they are in the database the backup is just one huge file that has to be backed up every time. Just dealing with the IO takes much longer, not to mention disk storage and possibly network bandwidth.
If you need to restore a single image you are going to need to create a whole database just to hold the backup before pulling out the one image - depending on how much data you have this can take hours. But with a file it's trivial.
- jrs235 15y agoOkay, the incremental argument carries no weight. You could do a differential backups of the database. If you are also doing transaction log backups restoring a file that was deleted is fairly trivial too.
- gaius 15y agoIf they are in the database the backup is just one huge file that has to be backed up every time. This is simply not true, in fact it is so not true that I must assume you have never actually used a database.