I am trying to design a web site with backup in mind. Large media elements would be stored on the file system and a daily backup would be done both for the DB and the file-system (which would hold the media elements).
While backing up the DB seems straight-forward I am curious about backing up the file system. WinRAR allows incremental backup and it's nice and dandy but I wish the site would be fully-usable while the file-system backup is taking place.
What if this (FS) backup takes 10 minutes and a user adds/modifies/deletes a (dozen of) file(s)?
SQL Server 2008 R2 guarantees the consistency of a backup by having a two step process.
- Backups all the data up to the backup start point
- Backs up the rest of the changes since the start of the backup and it's end
I don't know if something equally awesome could be done to the file system...