{"id":33717,"date":"2018-11-27T21:24:46","date_gmt":"2018-11-27T17:24:46","guid":{"rendered":"https:\/\/www.msp360.com\/resources\/?p=33717"},"modified":"2025-02-12T12:09:05","modified_gmt":"2025-02-12T08:09:05","slug":"differential-backup-explained","status":"publish","type":"post","link":"https:\/\/www.msp360.com\/resources\/blog\/differential-backup-explained\/","title":{"rendered":"Differential Backup Explained and Compared to Incremental"},"content":{"rendered":"<p>In this article, we will overview differential backup and its specifics. This type of backup cannot be used for file-level or <a href=\"https:\/\/www.msp360.com\/resources\/blog\/file-level-vs-image-level-backup\/\">image-based backups<\/a>. However, there is a popular scenario where you can meet and should use differential backup. Continue reading to learn more about this type of backup and the difference between incremental and differential backup.<br \/>\n<!--more--><\/p>\n<h2>What Is a Differential Backup?<\/h2>\n<p>A differential backup is a type of backup that uploads the <b>new and updated files <\/b>after the <b>first<\/b> full backup. It\u2019s essential to remember that each consequent differential backup compares the dataset only with the initial full backup.<\/p>\n<div><\/div>\n<div class=\"image-set\" style=\"width: auto;\">\n<div class=\"image-title\">Differential backup<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-27129 size-full\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2018\/11\/Differential-backup-difference.png\" alt=\"Differential backup: difference from the full backup diagram\" width=\"295\" height=\"179\" \/><\/p>\n<\/div>\n<h2>Facts About Differential Backup<\/h2>\n<ol>\n<li>It\u2019s faster to perform a differential backup than to perform a full backup<\/li>\n<li>A differential backup will become larger than a full backup. Thus, you need to run another full backup from time to time.<\/li>\n<li>It\u2019s easier and faster to recover files from a differential backup than from an<a href=\"https:\/\/www.msp360.com\/resources\/blog\/incremental-backup-guide\/\"> incremental backup<\/a>. The reason is the architecture of both solutions.<\/li>\n<\/ol>\n<div class=\"call-to-action\">\n<div class=\"call-to-action__left\">\n<div class=\"call-to-action__tag\">FREE WHITEPAPER<\/div>\n<div class=\"call-to-action__title\">Full System Backup and Recovery<\/div>\n<div class=\"call-to-action__text\">Check out our comprehensive guide covering system state, system image, and application-aware backup and recovery, as well as bare-metal recovery:<\/div>\n<!--HubSpot Call-to-Action Code --><span class=\"hs-cta-wrapper hs-cta-deferred\" id=\"hs-cta-wrapper-64dcb3ac-a304-4fdc-a704-c1242185e7c4\" data-portal=\"5442029\" data-id=\"64dcb3ac-a304-4fdc-a704-c1242185e7c4\"><span class=\"hs-cta-node hs-cta-64dcb3ac-a304-4fdc-a704-c1242185e7c4\" id=\"hs-cta-64dcb3ac-a304-4fdc-a704-c1242185e7c4\"><!--[if lte IE 8]><div id=\"hs-cta-ie-element\"><\/div><![endif]--><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/5442029\/64dcb3ac-a304-4fdc-a704-c1242185e7c4\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"hs-cta-img\" id=\"hs-cta-img-64dcb3ac-a304-4fdc-a704-c1242185e7c4\" style=\"border-width:0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/5442029\/64dcb3ac-a304-4fdc-a704-c1242185e7c4.png\" alt=\"CTA\"><\/a><\/span><\/span><!-- end HubSpot Call-to-Action Code -->\n<\/div>\n<div class=\"call-to-action__right\"><img decoding=\"async\" style=\"max-width: 200px;\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2018\/02\/Full-System-Backup-WP-icon.png\" alt=\"WP icon\" \/><\/div>\n<\/div>\n<h2>Incremental vs Differential Backup<\/h2>\n<p>Incremental and differential backups both perform a backup of changed and modified files. However, there is a distinct difference between incremental and differential backup.<\/p>\n<h3><b>Storage Space<\/b><\/h3>\n<p>A differential backup grows over time, as it consists of all the changes since the initial full backup. Thus, differential backup is slower and takes more storage space than an incremental backup.<\/p>\n<h3><b>Cost<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">If you compare the cost of a differential backup with an incremental one, you\u2019ll find that the former is more costly than the latter. This is because cumulative differential backup will take more storage space over time than the incremental backup process. It will consume more resources, and you either need to get additional storage or require an audit to perform a clean-up in order to continue using this strategy. If you need cost-effective <\/span><b>backup operations<\/b><span style=\"font-weight: 400;\">, you should go with an incremental one.<\/span><\/p>\n<h3><strong>Backup Speed<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">Another difference between differential and incremental backup processes is their backup speed. An incremental backup requires one full backup and then<\/span><b> subsequent backups<\/b><span style=\"font-weight: 400;\"> over time. On the other hand, the differential backup process requires one full backup that is the source of comparison for subsequent differential backups.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Let\u2019s understand that with an example.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Your IT staff performs a full backup on Sunday and schedules incremental backups on Monday, Tuesday, etc.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If your staff is using a differential backup strategy, the system will create backup files of all changes that occur on Monday and then all changes that happen on Tuesday, alongside any changes that occurred on Monday since Sunday.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Since incremental backup takes less space, its backup speed is quicker than a differential one.<\/span><\/p>\n<h3><b>Data Restoration Speed<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">The purpose of backing up is to streamline the restoration process. You should be able to recover data as and when required. In the case of differential backup, the recovery process requires you to have one full backup file and a recent differential backup file. Since a few steps are required in differential backup, the recovery time is quick in this backup strategy.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">On the flip side, if you have implemented an incremental backup process in your system, the whole process of recovery takes more time. It requires you to have a full backup file and also multiple backup copies. In the event that one of the subsequent increment copies is missing or corrupted, recovery time will increase.\u00a0<\/span><\/p>\n<p><span class=\"further-reading \">Further reading<\/span> <a href=\"https:\/\/www.msp360.com\/resources\/blog\/rto-vs-rpo\/\">Understanding RPO and RTO<\/a><\/p>\n<p><span style=\"font-weight: 400;\">You can go with an incremental backup recovery process when you only need partial data restoration.<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">During a recovery, incremental backup software needs to process each increment change and the first full backup to restore data to the required state. This process is slower compared to recovery from a differential backup.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">In an incremental backup, each next incremental change relies on the <\/span><b>previous backup<\/b><span style=\"font-weight: 400;\">. This means that if any of the changes are lost, the whole dataset is lost. To recover from the differential backup, you only need two \u201cfiles\u201d \u2013 the initial full backup and the latest differential backup.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Since incremental backups are typically smaller, they can run more often, and more data is preserved in the event of a disaster. Incremental backup allows better RPO in comparison to differential backup.<\/span><\/li>\n<\/ul>\n<p><a name=\"SQL\"><\/a><q>Nowadays, <span style=\"font-weight: 400;\">incremental backup has become the most common type used to back up various files and datasets<\/span>. By default, most backup software developers implement an incremental backup. <a href=\"https:\/\/www.msp360.com\/resources\/blog\/microsoft-sql-server-differential-backup\/\">SQL Server differential backup<\/a> is a typical use case of differential backup. For other datasets, differential backup is not used and cannot be enabled in most backup software solutions.<\/q><\/p>\n<h3><b>Cloud Compatibility<\/b><\/h3>\n<p>If you have a plan for digital transformation and you want to pick a <a href=\"https:\/\/www.msp360.com\/resources\/blog\/3-steps-for-efficient-backup-strategy\/\">backup strategy<\/a> that consumes less space but offers optimal results, then you need to go with the incremental backup technique. It\u2019s suitable for the cloud as it requires less space and backup time, although the data recovery process will take time. Since this type of backup doesn\u2019t require much space, it will reduce the cost of <a href=\"https:\/\/www.msp360.com\/resources\/blog\/benefits-cloud-storage\/\">cloud storage<\/a>.<\/p>\n<h2>Differential Backup Use Case: Microsoft SQL Server<\/h2>\n<p>To understand how the differential backup works, we will review how it\u2019s used in the backup of Microsoft SQL Server. Microsoft has developed a native backup structure in three layers for its SQL Server databases:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29756 size-full alignleft\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2019\/03\/Full_backup.png\" alt=\"Full backup\" width=\"163\" height=\"214\" \/><\/p>\n<p><b style=\"padding-top: 50px; display: inline-block;\">Full backup<\/b><\/p>\n<p>A backup of the whole database. This is the largest of the three backups; you don\u2019t want to run it very often.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29757 size-full alignleft\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2019\/03\/Differential_backup.png\" alt=\"Differential backup\" width=\"163\" height=\"128\" \/><\/p>\n<p><b style=\"padding-top: 20px; display: inline-block;\">Differential backup<\/b><\/p>\n<p><a href=\"https:\/\/www.msp360.com\/resources\/blog\/microsoft-sql-server-differential-backup\/\">SQL Server differential backup<\/a> contains all changes since the initial full backup. The Microsoft SQL Server database is designed in such a way that it\u2019s technically possible to back up only the changed parts of the dataset.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-29758 size-full alignleft\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2019\/03\/T-log_backup.png\" alt=\"T-log backup\" width=\"163\" height=\"128\" \/><\/p>\n<p><b>Transaction log backup<\/b><\/p>\n<p id=\"last\">The SQL Server database creates a highly detailed map of the database - that\u2019s transaction logs. If the database and differential backups are lost or unrecoverable, the <a href=\"https:\/\/www.msp360.com\/resources\/blog\/sql-server-transaction-log-backup\/\">transaction log backup<\/a> chain is enough to recover the latest recorded state. Backup of the T-logs usually takes less time than a full or differential backup.<\/p>\n<div id=\"slidebox\"><!--HubSpot Call-to-Action Code --><span class=\"hs-cta-wrapper hs-cta-deferred\" id=\"hs-cta-wrapper-aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6\" data-portal=\"5442029\" data-id=\"aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6\"><span class=\"hs-cta-node hs-cta-aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6\" id=\"hs-cta-aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6\"><!--[if lte IE 8]><div id=\"hs-cta-ie-element\"><\/div><![endif]--><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/5442029\/aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"hs-cta-img\" id=\"hs-cta-img-aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6\" style=\"border-width:0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/5442029\/aa07fdb8-7776-46a5-9fa0-ec6e93f0f0a6.png\" alt=\"CTA\"><\/a><\/span><\/span><!-- end HubSpot Call-to-Action Code --><\/div>\n<div class=\"clear\" style=\"clear: both;\"><\/div>\n<p><q>All three backup types are complementary to each other in the SQL Server. You will be able to achieve lower downtime and lose less data while restoring from a chain of full-differential-transaction logs.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29754 size-full\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2019\/03\/SQL_Server_backup_chain.png\" alt=\"SQL Server backup chain\" width=\"724\" height=\"247\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2019\/03\/SQL_Server_backup_chain.png 724w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2019\/03\/SQL_Server_backup_chain-300x102.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2019\/03\/SQL_Server_backup_chain-624x213.png 624w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><br \/>\n<span class=\"further-reading\">Further reading<\/span> <a href=\"https:\/\/www.msp360.com\/resources\/blog\/sql-server-backup-and-restore\/\">Microsoft SQL Server Backup and Restore<\/a><br \/>\n<\/q><\/p>\n<h2>Conclusion<\/h2>\n<p><span style=\"font-weight: 400;\">A differential backup is a highly specific backup technique, and it is not used for datasets outside of SQL Server databases. When considering other types of backup, like file-level or image-based backups, a differential backup is proven to be ineffective.<\/span> You can go with incremental backup during the digital transformation process, as it speeds up the backup process while allowing you to save money in the long run.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we will overview differential backup and its specifics. This type of backup cannot be used for file-level or image-based backups. However, there is a popular scenario where you can meet and should use differential backup. Continue reading to learn more about this type of backup and the difference between incremental and differential [&hellip;]<\/p>\n","protected":false},"author":46,"featured_media":44446,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[886,878],"tags":[930],"class_list":["post-33717","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-backup-and-dr-guides","category-msp-university","tag-backup-types-comparison"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/33717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/users\/46"}],"replies":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/comments?post=33717"}],"version-history":[{"count":7,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/33717\/revisions"}],"predecessor-version":[{"id":59543,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/33717\/revisions\/59543"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/media\/44446"}],"wp:attachment":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/media?parent=33717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/categories?post=33717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/tags?post=33717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}