On Feb 4, 2008 5:26 PM, Miguel Gonzalez Castaños <[EMAIL PROTECTED]> wrote: > Full backups one day a week and then perform incremental backups (or > differential backups ...
Logically speaking: - Full = Everything - Incremental = Changes since last incremental or full backup - Differential = Changes since last full backup So, on a restore: - Incremental = Restore most recent Full, then each Incremental since that Full - Differential = Restore most recent Full, then the most recent Differential In practice, with databases, this is often implemented by having the Full and Incremental backup routines clear transaction logs, but having the Differential routine leave transaction logs there (for the next Differential). > However, my big concern is that if any of the > incremental backups goes wrong, you lose up to the only backup that was > good. Yup! That is one of the drawbacks to incremental backups. > Is it possible to access within the differential backup the files > that were created or modified that day without needing to restore the > full backup? With NTBACKUP, for regular files, yes. Not for databases/Exchange. > What is the best scheme that I should use for each of the servers > (differential, incremental). Is good my approach of creating an > incremental (or differential) backup from the full backup of monday? What you describe is simply called a "Differential backup", and should work. -- Ben ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
