No matter the task you're performing in SQL Server, backups are essential to protect your data. Learn what SQL Server backups are, how they work, how to perform backups, and how to put together an effective backup strategy for your environment.
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.
Paul is the CEO of SQLskills.com, a Microsoft Regional Director and a SQL Server MVP. He worked on the SQL Server Storage Engine team at Microsoft from 1999 to 2007. Among other things, he wrote DBCC CHECKDB/repair for SQL Server 2005 and was responsible for the Core Storage Engine during SQL Server 2008 development.
Course Overview [Autogenerated] Hello, My name is Paul Randall and welcome to my course sequel server. Understanding on Performing Backups. I'm a single server consultant with sequel skills as well as a Microsoft data platform. M V. P. On this topic is one that I've been presenting for many years because I find that many data professionals don't understand how backups work the problems You can run into Iran backups on how to formulate an effective backup strategy. It's really impossible to escape the need for backups as whatever you're doing with Sequel server, you're at least going to want to protect your data. In this course, we're going to cover what the various kinds of backups are and how they work, including topics like transactional clearing and performing special tail. The log backups will discuss how to put together a backup strategy based on business requirements and how your restore strategy really dictates what backups you need to perform. Finally will examine a bunch of common backup options, including backup compression, backup encryption and backup integrity. By the end of this course, you'll have a really good understanding of why backups are important, how backups work and how to create an effective backup strategy for your environment. If you work with sequel server in any capacity, whatever your level, this course is relevant to you, and you only need a basic understanding of civil server to comfortably follow along. I hope you'll join me here as we explore the many aspects of backups in this course sequel, server understanding and performing backups here on plural site.