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

6. Differential Restores

Bradley Beard1 
Palm Bay, Florida, USA

Back in Chapter 2, we went over the fundamentals of differential backups and how important the differential base is to the overall recovery strategy. Those same principals apply to differential restores, except that we are now dealing with the other end of the transaction, so to speak. The choice of recovery models is the single most important aspect to determining the efficacy of the restore methods that are available to you. Recall that we used the full recovery model for our test database; this means that we have access to the full range of backup and restore ...

Get Beginning Backup and Restore for SQL Server: Data Loss Management and Prevention Techniques now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.