Beginning Backup and Restore for SQL Server: Data Loss Management and Prevention Techniques

© Bradley Beard 2018

Bradley BeardBeginning Backup and Restore for SQL Serverhttps://doi.org/10.1007/978-1-4842-3456-3_10

10. Differential Backup and Restore Solutions

Bradley Beard¹ 

(1)

Palm Bay, Florida, USA

 

Now that we have functional full backup and full restore SQL Server Agent jobs detailed in Chapter 9, we need to piece together the differential backup and differential restore parts. We are going to draw from Chapter 2 and Chapter 6 for this chapter, but we will be looking at adding slightly different functionality and customization to our existing Backup Plan maintenance plan.

What we want to do is rework the backup plan to include the differential portion of the backup, and then create a new Differential Restore SQL Server Agent job to be ...