MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server High Availability and Disaster Recovery (HA/DR)

Course Summary

Dive deep into how SQL Server works to implement an effective high availability and disaster recovery solution.


  • +

    Course Syllabus

      • Introduction
      • The Need for High Availability and Disaster Recovery
    • Non-Technology Aspects of High Availability and Disaster Recovery
      • Non-Technology Aspects of HA/DR
      • BIA, RPO, RTO, SLA, etc. Acronyms That Need To Drive HA/DR Projects
      • The Lion, The Switch and the Wardrobe
    • SQL Server Recovery Models
      • SQL Server Database Recovery Models
      • Demo: SQL Server Database Recovery Models
      • Demo: The Risk of Switching Recovery Models
    • SQL Server Database Backups
      • Database Backups
      • Demo: Understanding Multi-base Differential Backups
    • SQL Server Transaction Log Internals
      • Inside the SQL Server Transaction Log
      • Demo: Inside the SQL Server Transaction Log
      • Demo:Effects of the Transaction Log Filling Up
    • SQL Server Database Restore and Recovery
      • Database Restore and Recovery
      • Factors Affecting Restore And Recovery
      • DEMO:Effects of Instant File Initialization
      • Demo: Database Recovery Techniques
    • SQL Server System Databases
      • Protecting System Databases
      • Demo: Protecting System Databases
    • SQL Server Database Mirroring
      • Understanding and Implementing SQL Server Database Mirroring
      • Demo: Implementing Database Mirroring - The Simple Way
      • Demo: Implementing Database Mirroring on Workgroup Servers - The Hard Way
    • SQL Server Log Shipping
      • Understanding and Implementing SQL Server Log Shipping
      • Demo: Implementing SQL Server Log Shipping
    • SQL Server Failover Clustering
      • SQL Server Failover Clustering Fundamentals
      • Demo: Implementing SQL Server Failover Clustered Instances From Start to Finish
      • Demo: SQL Server 2012 Multi-Subnet/Geographically-Dispersed Failover Clusters
    • SQL Server 2012 Availability Groups
      • Understanding and Implementing SQL Server 2012 Availability Groups
      • Demo: SQL Server 2012 Availability Groups Configuration
      • Demo: Multi-Site/Geographically Dispersed SQL Server 2012 Availability Groups
    • SQL Server Replication
      • SQL Server Replication
      • Course Summary


Course Fee:
USD 315

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top