08-506 668 00
Training You Can Trust®
 
 

SQL Server High Availability: Hands-On

 
Kurs: 141   Längd: 3 dagar
 
 

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: databasadministration
  • 535 Högpresterande SQL Server-databaser
  • 961 Windows Server 2008: administration
  • 1510 Administrera SharePoint Server 2010
  • 532 SQL Server Transact-SQL-programmering
  • 296 Projektledning
  • 2105 SQL Server 2012: DBA uppdateringskurs

 
SQL Server 2008 is a registered trademark of Microsoft Corporation. 		  SQL Server High Availability

Kursschema

Learning Tree AnyWareDu kan gå de överstrukna kurserna i klassrummet eller live, online via Learning Tree AnyWareTM.

Storbritannien

8 - 10 febLondon 
27 - 29 juniLondon 

USA

2 - 4 majReston, VA 
16 - 18 majRockville, MD 
13 - 15 juniNew York 

När du ska gå en AnyWare-kurs bör du anmäla dig minst 10 dagar före kursstart.


För fler kursdatum besök www.learningtree.se
 
http://www.learningtree.se/courses/se141.htm
 
 
08-506 668 00
Training You Can Trust®
 
 

SQL Server High Availability: Hands-On

 
Kurs: 141   Längd: 3 dagar
 
 
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.se/courses/se141.htm
 
 
08-506 668 00
Training You Can Trust®
 
 

SQL Server High Availability: Hands-On

 
Kurs: 141   Längd: 3 dagar
 
 
Kurspriser
19 950 krOrd. Pris
kurspriser med
rabattprogram
14 300 krMed Treklöver
12 975 krMed Fyrklöver
17 350 krMed Företagskort -
10-kort
13 020 krMed ProPack 40
Alla priser i SEK, exkl moms.

I kursavgiften ingår bl a...

  • Kursplats
  • Gruppövningar
  • Tillgång till klassrumsutrustning
  • Omfattande kursmaterial
  • Lunch
  • För- och eftermiddagsfika
  • Kursdiplom
  • Kostnadsfritt deltagande i våra specialiserade Certifieringsprogram (inkl. tillhörande examenstester)
  
 

Nyttja våra förmånliga erbjudanden och avtal

Learning Trees Två-, Tre- och Fyrklöver
  • Personligt rabattprogram med 2, 3 eller 4 valfria kurser
  • Upp till 50 % rabatt per kurs jämfört med ord. pris
  • Läs mer på www.learningtree.se/klover
Learning Trees Företagskort
  • Flexibelt och kostnadseffektivt som ger upp till 35 % rabatt kurs jämfört med ord. pris
  • Utbilda valfri medarbetare, när som helst och var som helst under 12 månader
  • Läs mer på www.learningtree.se/foretagskort

Vi garanterar att du blir nöjd

Om du inte känner dig 100 % övertygad om att Learning Tree har levererat vad du förväntat dig så tar vi inte ut någon avgift för ditt kursdeltagande. Vår kvalitetsgaranti ger den enskilde deltagaren möjlighet att efter genomförd kurs endast betala om kursen uppfyller deltagarens förväntningar.

Boka dig idag!

Vårt omfattande kursschema ger dig möjlighet att välja både datum och kursort för din utbildning. Ring 08-506 668 00 eller boka dig online.
 
http://www.learningtree.se/courses/se141.htm