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_9

9. Full Backup and Restore Solutions

Bradley Beard¹ 

(1)

Palm Bay, Florida, USA

 

In the “real world,” there is a definite business need to have reliable backups available at a moment’s notice. The eventuality of data corruption is almost a guarantee, so the seasoned DBA must know that their database can be restored quickly and correctly. The availability and reliability of the backup are of utmost importance, whether backups are stored in a remote location or they are stored local to the database server. We often deal with service-level agreements, or SLAs, in our backup and recovery practices. This sort of document deals with a ...