0800 282 353 or +44 1372 364610

Productivity through Education®

SQL Server High Availability: Hands-On

Course: 141 Type: Hands-On Training Duration: 3 Days

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

Related Courses

138 SQL Server 2008 Database Administration
535 High-Performance SQL Server Databases
961 Windows Server 2008 Administration
1510 Administering SharePoint Server 2010
532 SQL Server Transact-SQL Programming
296 Project Management: Skills for Success

SQL Server 2008 is a registered trademark of Microsoft Corporation.

Upcoming Dates

5 - 7 Jan

London

11 - 13 May

London

Attend highlighted events
in person or online with Learning Tree AnyWare^TM.

For complete schedule, please visit www.learningtree.co.uk

http://www.learningtree.co.uk/courses/uk141.htm

0800 282 353 or +44 1372 364610

Productivity through Education®

SQL Server High Availability: Hands-On

Course: 141 Type: Hands-On Training Duration: 3 Days

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

http://www.learningtree.co.uk/courses/uk141.htm

0800 282 353 or +44 1372 364610

Productivity through Education®

SQL Server High Availability: Hands-On Tuition

Course: 141 Type: Hands-On Training Duration: 3 Days

Course Fees

£ 1,475	Standard Fee
Savings Plans
£ 1,000	Flex-Training Pass
£ 750	10-Day Training Pass
£ 1,520	Voucher 10-Pack
£ 1,330	Alumni Gold Discount

Your Course Fee Entitles You To...

Class participation
Team workshops
Use of in-class hands-on equipment
Comprehensive course materials
Morning and afternoon refreshments
Course Completion Certificate
FREE participation in the Learning Tree Professional Certification Programmes (including related exams)

Tuition Savings Plans

Flex-Training Pass	3 Courses for �2,995 As little as �1,000 Savings as much as 50% 3 courses in 24 months
10-Day Training Pass	Save as much as �895 per course Any combination of courses Only �2,495
Training Vouchers	Save as much as �625 per course Fully transferable As low as �1,520 per course
Alumni Gold Discount	Attend your first course and you will receive a personalised Alumni Gold Discount card, entitling you to save as much as �210 on each course you take in the following 24 months. Take just one course every two years, and you will be entitled to ongoing discounts...year after year. You save 10%.

* Exact savings may vary depending on courses selected.

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course - and then pay only if you feel the course was well worth the fee.

Enrolling is Easy and Flexible!

Enrol by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.

http://www.learningtree.co.uk/courses/uk141.htm