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

1. Full Backups

Bradley Beard1 
(1)
Palm Bay, Florida, USA
 

The concept of backing up data is one of those things that should be extremely intuitive, but is often implemented poorly, if at all. I know quite a few database administrators (DBAs) that don’t worry about regular, structured backups because their database server is on a SAN (storage area network) and the data is therefore backed up regularly. To me, this makes no sense at all, since there is absolutely no contingency for point-in-time restoration of data, outside of what happened to have been backed up as part of a complete Windows backup solution. If there were a catastrophic ...

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.