Setting up a structured, recurring backup does not stop with just a scheduled full backup. That is only half the battle; to be honest, a third of the battle. A good backup strategy reduces the overall risk to the data stored in the database. One of the most effective ways to reduce risk is by decreasing the total number of “links” in your backup chain (i.e., the total number of files you have to restore in the case of a disaster). Every file that gets created during a backup has a chance of being corrupted. If you have a large number of backups in a restoration, ...
© Bradley Beard 2018
Bradley BeardBeginning Backup and Restore for SQL Serverhttps://doi.org/10.1007/978-1-4842-3456-3_22. Differential Backups
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.
