Tarek Chaaban

Tarek Chaaban, M.Sc's official blog. It contains current web project portfolio, posts regarding his Canadian army experience, news, sports articles, and web tutorials on programming and using social networking technologies.

Complete backup vs. differential backup of DATABASE

Question :

Hi Tarek , May i ask about:
Complete backup vs. differential backup of DB

Differential Backup

A differential backup will backup all files that have changed since the last full backup. In other words, if a full backup was done on Monday, Tuesday’s differential will backup all changed files since Monday’s full. Wednesday’s differential will backup all changed files since Monday’s full including the files that have changed on Tuesday.

The big advantage to this method comes when performing a complete restore since only the full and latest differential backups need to be restored. The downside is that the size of the differential backup will grow throughout the week and become progressively larger until the next full. This can adversely affect backup windows.

Full Database Backup:

A full database backup backs up the whole database. This includes part of the transaction log so that the full database backup can be recovered. Full database backups represent the database at the time the backup finished.

1 Comment

  1. i appreciat if u answer me how could i clean my computer of viruses

Leave a Response

Please note: comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.