September 23, 2008 at 2:55 pm
Well, gee - oooops, it seems my information about differential backups was somewhat inaccurate then. (Thanks Gail for pointing that out.:P) A differential backup is a backup of all pages changed since your last full backup.
So, in the restore situation I described above, you would only need to restore your full backup + your most recent differential backup, not all differential backups since your last full backup.
The original post has been edited to reflect this. 🙂
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply