SQL Server 2016 - Maintenance & Automation : High Availability and Disaster Recovery | packtpub.com

3,429 views · Published 7 July 2017 · 10:26 · Indexed 8 November 2026

Channel: Packt · 2017 · Science & Technology

Watch on YouTube

This playlist/video has been uploaded for Marketing purposes and contains only selective videos. 

For the entire video course and code, visit [http://bit.ly/2tPu6gI].

In this section, we’ll take a look at the high availability and disaster recovery aspects of SQL Server. First, we’ll go through clustering and learn how to configure a cluster and how to failover a cluster. Then, we’ll look at availability groups and learn how to administer an availability group. Next, we’ll cover database mirroring and learn how to setup database mirroring. Later, we’ll understand what log shipping is and learn how to setup log shipping between two different instances. Finally, we’ll take a look at replication and understand how to configure transactional replication between two databases. 
• Clustering 
• Availability Groups 
• Database Mirroring 
• Log Shipping 
• Replication 


For the latest  Big Data and Business Intelligence video tutorials, please visit
http://bit.ly/1HCjJik

Find us on Facebook -- http://www.facebook.com/Packtvideo
Follow us on Twitter - http://www.twitter.com/packtvideo

More from this channel