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 ...
© Bradley Beard 2018
Bradley BeardBeginning Backup and Restore for SQL Serverhttps://doi.org/10.1007/978-1-4842-3456-3_66. Differential Restores
Bradley Beard1
(1)
Palm Bay, Florida, USA
Get Beginning Backup and Restore for SQL Server: Data Loss Management and Prevention Techniques now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
