|
|
|
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
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
Related Courses
SQL Server 2008 is a registered trademark of Microsoft Corporation.
|
|
Course Dates
UK Dates | | 8-10 Feb | London enrol | | 27-29 Jun | London enrol | | 21-23 Nov | London enrol | US East Coast Dates | | 2-4 May | Washington, DC enrol* | | 16-18 May | Washington, DC enrol* |
*New York and Washington DC Courses – Available online with a run time of 2pm to 9pm BST. For AnyWare enrolments, please register at least 10 days prior to the start of the course.
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.
|
Course participants creating a SQL Server failover cluster.
|
|
Average Attendee Evaluation
|
Evaluations in the last 12 months |
|
5 stars:
|
|
69% |
|
4 stars:
|
|
26% |
|
3 stars:
|
|
5% |
|
2 stars:
|
|
0% |
|
1 star:
|
|
0% |
|
"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
|
|
 |
|
E-mail 
Print 
Q&A 
PDF 
Facebook 
Twitter
