From the course: Microsoft SQL Server 2022 Essential Training
Unlock this course with a free trial
Join today to access over 23,400 courses taught by industry experts.
Business continuity solutions - SQL Server Tutorial
From the course: Microsoft SQL Server 2022 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 it'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 it contains, are highly available whenever they're required and the streamlined 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 users as normal. It then copies those instructions to one or more…
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.