SQL Server: Understanding and Performing Backups

  • Course level: All Levels


It’s really impossible to escape the need for backups even if you have some sort of synchronous replica of your databases, disasters can still happen that require restoring from backups. This means it’s critical that you understand what backups are and how to create them. In this course, SQL Server: Understanding and Performing Backups, you’ll learn what SQL Server backups are, why they’re required, and how they work. First, you’ll explore how to formulate a backup strategy based on business requirements and what restores you may need to perform. Next, you’ll delve into commonly used backup options. Finally, you’ll discover how to use backup compression, backup encryption, and maintain backup integrity. When you’re finished with this course, you’ll have the skills and knowledge to confidently perform backups in your environment and create a backup strategy.