- Använd denna eller någon annan utbildning i ditt företag
- Fullskalig programutveckling
- Levereras när, var och hur du vill
- Blandade utbildningsmodellerSkräddarsytt innehåll
- Coaching av ett expertteam
#141
SQL Server High Availability Training
Course 141
- Labs: Yes
- Language: English
- Level:
SQL Server provides a full range of technologies that allow organisations to reduce downtime and maintain high levels of availability. In this SQL Server High Availability training course, you gain experience using SQL Server 2017 AlwaysOn technologies for building a variety of high availability solutions, and learn how to implement failover clustering, log shipping, database mirroring, and peer-to-peer transactional replication.
In this 3-day SQL Server High Availability course, you learn to maintain a large number of constantly available database servers to ensure disaster recovery.
SQL Server High Availability Training Delivery Methods
- After-course instructor coaching benefit
- Learning Tree end-of-course exam included
SQL Server High Availability Training Course Benefits
Design a service level agreement that matches business requirementsPlan, prepare, and install a SQL Server failover clusterMirror a database to ensure instant failoverAutomate deployment with AlwaysOn technologiesEnsure business continuity through failover clusterSQL Server High Availability Course Outline
Characterising high availability
- The "five nines"
- Site
- Instance
- Database
- Defining a service level agreement
Planned vs. unplanned downtime
- Performing routine maintenance
- Recovering from disasters
- Handling hardware failures
Defining components of a cluster
- Single-instance architecture
- Multi-instance architecture
- Shared storage
- Resource group
- Heartbeat
- Quorum
Preparing for Windows failover clustering
- Configuring an iSCSI target
- Managing shared storage
- Installing the failover clustering feature
Planning for SQL Server failover clustering
- Determining the correct version of Windows Server
- Upgrading to SQL Server 2012
- Leveraging virtual machines for clustering
Creating a SQL Server failover cluster
- Installing a new failover cluster
- Adding a new node
- Failing over to a passive node
Preparing for a warm standby server
- Synchronising logins
- Creating network shares
Implementing transaction log shipping
- Specifying log backup frequency
- Configuring the log shipping monitor
Switching to the standby server
- Redirecting applications
- Bringing the standby online
Comparing mirroring architectures
- High availability
- High protection
- High performance
- Full safety vs. safety off
Getting ready for mirroring
- Setting the recovery model
- Selecting the principal, mirror and witness servers
Mirroring a database
- Configuring the principal, mirror and witness servers
- Initiating the mirroring session
Administering mirroring
- Enabling and disabling mirroring with scripts
- Launching the Database Mirroring Monitor (DMM)
Employing a mirror for reporting
- Taking a database snapshot
- Querying a snapshot of the mirror
Enhancing the capabilities of database mirroring
- Database mirroring with multiple databases and multiple mirrors
- Manually failing over a group of databases
Clustering and deployment
- Multi-site clustering across subnets
- Automating deployment using AlwaysOn PowerShell cmdlets
- Monitoring the high-availability configuration using the AlwaysOn dashboard
Selecting the appropriate strategies
- Determining the pros and cons of each HA technology
- Failover clustering with a mirror
Pulling it all together
- Creating a complete high-availability solution
- Evaluating the results
Questions about this course?
Customise Your Team Training Experience
Fill out the form below or call +46 (0)8 506 668 00
Need Help Finding The Right Training Solution?
Our training advisors are here for you.
Course FAQs
SQL Server High Availability allows 24 hour access to its database if any problem were to arise and you need immediate solutions.
The applicable version for this course is SQL Server 2017.
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want.