question

Steve Jones - Editor avatar image
Steve Jones - Editor asked

Full v Differential backups

What is the difference between a full and a differential backup?

sql-serverbackuprestore
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Jorge Segarra avatar image
Jorge Segarra answered

Full backup gets all the data and pages. Differential backup only gets the pages that have changed since previous full backup. Ultra-simplified explanation. To get more in-depth information on all things backups check out Paul Randal's blog:

http://www.sqlskills.com/BLOGS/PAUL/category/BackupRestore.aspx - Link to his backup/restore articles

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

venkatreddy avatar image
venkatreddy answered

Full backup will backup's the complete data available on data file.Diffrential backup backs up the changes made to the database from the previous or last full backup

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.