SQL Server 2014 Backup and Recovery

As a database administrator there are certain skills that you are expected know and know extremely well. Two of those skills are making backups and performing restores. Backups and restores are the core foundation of a DBA’s job. This book is designed to help the beginner and mid-level DBA to get a strong understanding of the types of backups available within SQL Server and how to restore each of those backups. This book covers the newest backup features such as backing up to Azure Storage and native SQL Server encryption.

Table of Contents

Chapter 1. SQL Server Database Files
Chapter 2. Performing a Full SQL Server Backup
Chapter 3. Differential SQL Server Backups
Chapter 4. Transaction Log Backups
Chapter 5. Common Restore Strategies
Chapter 6. Copy Only Backup
Chapter 7. File and Filegroup
Chapter 8. Backing Up System Databases
Chapter 9. Additional Best Practices
Chapter 10. Encryption
Chapter 11. Back Up to Microsoft Azure Storage