From the course: Microsoft SQL Server 2019 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Business continuity solutions - SQL Server Tutorial
From the course: Microsoft SQL Server 2019 Essential Training
Business continuity solutions
- [Instructor] Having a backup and restore plan in place ready to go when disaster strikes is an essential practice for anyone that works with a database management system, but if you can reduce the risk of even having a catastrophic failure in the first place, then that'll go a long way towards securing your information too. SQL Server offers a couple of advanced data protection features that fall under the concept of business continuity. The goal here is to make sure that the server and the databases that they contain are highly available whenever they're required and to streamline disaster recovery efforts. The more powerful business continuity option is called availability groups. With availability groups, multiple server instances work together as a cluster to protect the data. A primary copy of the database receives read and write instructions from the users as normal. It then copies those instructions to one or more secondary replicas of the database, and they perform the same…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.