Building and Managing High Availability Solutions with SQL Server 2016 and 2014
This course provides an in-depth review of SQL Server 2014 High Availability, including concepts for HA, drill-through of the various technologies available with SQL Server 2014, and how to implement high availability using those technologies.
CÍLOVÁ SKUPINA
Those responsible for building and managing high availability solutions for SQL Server.
TÉMATA KURZU
• Build a reliable High Availability solution with Windows Server 2012 R2/2016 and SQL Server 2014/2016
• Manage a High Availability solution with Windows Server 2012 R2/2016 and SQL Server 2014/2016
• Build Disaster Recovery Solutions
• Troubleshoot problems with High Availability in SQL Server 2016 and 2014
Nahoru
OSNOVA KURZU
1 - HIGH AVAILABILITY OVERVIEW
Basic aspects of High Availability
2 - WINDOWS SERVER 2016 HIGH AVAILABILITY FEATURES OVERVIEW
Overview of HA features in Windows Server 2016
3 - SQL SERVER 2016 HIGH AVAILABILITY FEATURES OVERVIEW
Failover Cluster Instances
Availability Group
Log Shipping
4 - WINDOWS SERVER 2016 FAILOVER CLUSTERING
Installation
• Storage Configuration
• Quorum Configuration
Maintenance
• Patching/Upgrading
• Adding/Removing nodes to/from cluster
Monitoring
Troubleshooting
5 - SQL SERVER 2016 FAILOVER CLUSTERING INSTANCE
SQL Server FCI configuration
• Active/Active
• Active/Passive
• MS DTC
Maintenance
• Patching/Upgrading
• Adding/Removing SQL Server to/from cluster
Monitoring
Troubleshooting
6 - SQL SERVER 2016 AVAILABILITY GROUPS
SQL Server AG configuration
• Sync/Async
• Read Only Routing and Load Balancing
• Direct seeding
• Distributed AG
Maintenance
• Patching/Upgrading
• Adding/Removing files to/from database in AG
• Adding/Removing database to/from AG
Monitoring
Troubleshooting
7 - SQL SERVER INOPERABILITY
Inoperability
• With Integration Services
• With Analysis Services
• With Reporting Services
Aktuální osnova kurzu se může lišit v závislosti na pobočce, která ho nabízí. Více informací vám poskytnou naši obchodní zástupci.
