Learning Tree International

SQL Server Courses

0800 282 353 or +44 1372 364610
 

Request Info

Salutation

First Name

Last Name

Job Title

Company

Post Code

Country
List

Office Telephone

Extension

E-mail

A representative will contact you to follow up your request.

Save up to 50% per course
 

SQL Server® High Availability: Hands-On

Course 141 • 3 Days

  E-mail   Print   Q&A   PDF 

Quick Enrol

You Will Learn How To

  • Leverage SQL Server technologies to achieve high-availability database solutions
  • Design a Service Level Agreement that matches business requirements
  • Plan, prepare and install a SQL Server failover cluster
  • Maintain a warm standby server with log shipping
  • Mirror a database to ensure instant failover
  • Employ peer-to-peer transactional replication as a high-availability solution

Course Benefits

SQL Server provides a full range of technologies that allow organisations to reduce downtime and maintain high levels of availability. In order to achieve these goals, an enterprise database administrator must implement failover clustering, log shipping, database mirroring and peer-to-peer transactional replication. This course offers enterprise SQL Server administrators the skills to maintain a large number of constantly available database servers.

Who Should Attend

Anyone involved in planning, supporting or implementing a high-availability solution with SQL Server. Course 138, "SQL Server 2008 Database Administration", or equivalent experience, is assumed.

Hands-On Training

Throughout this course, a series of extensive hands-on exercises provides you with practical experience implementing high-availability solutions. Exercises include:
  • Identifying availability requirements
  • Installing a SQL Server Failover Cluster
  • Backing up and restoring databases with advanced features
  • Maintaining a warm standby server
  • Mirroring a database
  • Implementing replication
  • Integrating high-availability techniques

Course Content

High-Availability Fundamentals

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

Configuring hardware

  • RAID
  • SAN

Installing Windows 2008 Failover Clustering

Defining components of a cluster

  • Active-Passive architecture
  • Active-Active architecture
  • Shared storage
  • Resource Group
  • Heartbeat
  • Quorum

Preparing for Windows failover clustering

  • Setting up an iSCSI target
  • Managing shared storage
  • Configuring iSCSI initiators
  • Validating a cluster configuration
  • Installing the failover clustering feature
  • Creating a Windows Failover cluster

Establishing SQL Server Failover Clustering

Planning for SQL Server failover clustering

  • Upgrading from Windows Server 2003 to 2008
  • Migrating to SQL Server 2008
  • Leveraging virtual machines for clustering
  • Geographically dispersed clusters

Creating a SQL Server failover cluster

  • Installing a new failover cluster
  • Adding a new mode
  • Failing over to a passive node

Employing Log Shipping

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

Configuring Database Mirroring

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
  • 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

Leveraging Replication for High Availability

Laying out a replication strategy

  • Enumerating types of replication
  • Making the business case

Configuring Peer-to-Peer Transactional Replication

  • Creating distributors
  • Initialising databases
  • Creating and subscribing to a publication
  • Adding a node to a topology

Combining High-Availability Technologies

Selecting the appropriate strategies

  • Determining the pros and cons of each HA technology
  • Failover clustering with a mirror
  • Log shipping with a failover cluster

Pulling it all together

  • Creating a complete high-availability solution
  • Evaluating the results

<< Back to SQL Server Course List
 

Related Courses

SQL Server 2008 is a registered trademark of Microsoft Corporation.
 
SQL Server High Availability
Hands-On Training

Course Dates

29 Sep-1 OctLondon enrol
5-7 JanLondon enrol
11-13 MayLondon enrol

Attend highlighted events
in person or online with Learning Tree AnyWareTM.

More Dates and Locations.

On-Site &
Custom Training

Bring this or any Learning Tree course to your location or have it customised for your organisation.

Tuition

£ 1,475 Standard Tuition
Tuition with a Savings Plan
£ 1,000Flex-Training Pass
£ 75010-Day Training Pass
£ 1,520Voucher 10-Pack
£ 1,330Alumni Gold Discount
 
SQL Server High Availability: Hands-On

Course participants creating a SQL Server failover cluster.

 
"What impresses me about Learning Tree is the entire package. The facility is very comfortable and the information is presented in the class very well. The fact that the instructors are working in the field means they know what they're talking about".

– M. Fahlin
Ericsson AB



 
What's In It For You: Exploring the Benefits of the SQL Server 2008 Database Engine
Call 0800 282 353 or +44 1372 364610 today!