| Home |
| Articles |
| Backup |
| Books |
| Certification |
| FAQ |
| Products |
| Replication |
| Scripts |
| Seminars |
| Training |
| TSQL |
|
| MSDN Fourms |
| Philippine SSUG |
| Fort Worth SSUG |
| Oklahoma City SSDG |
|
| Resume |
|
| MHS Enterprises |
| BlowFrog Software |
| FilAm Software |
| AcrylicAcetate.com |
| Bargain Humidors |
| Western Humidor |
|
|
Microsoft SQL Server 2005 High Availability - Master Class
Class Scheduling
This class is currently taught as either a private class or through SQLearning. Contact us for more information.
Overview
Drawing on decades of practical experience, MHS Enterprises courses are a leap forward in content creation and delivery. Each Mentor teaching a course brings years of past and ongoing practical experience on the subject into the classroom to provide a unique perspective on the content delivered. Based on that practical experience, each mentor is equipped to answer any question which should arise and ensure that each delegate attending the class will leave with skills that can be applied immediately in their environment. Only the best content available coupled with the best instructors possible and utilizing the most current knowledge make it into an MHS course.
This course draws on over a decade of practical experience in High Availability processes and technology providing up to date information, not theory. When you leave this class, you will be able to:
- Install a cluster as well as improve the management and maintainability of any Windows or SQL Server cluster in your environment.
- Install, configure, and manage the new Virtual PC and Virtual Server platforms
- Expand and improve your disaster recovery plans
- Understand the differences between the replication options as well as have the experience to architect, install, and manage replication solutions
- Understand how to implement and combine the best choice of Clustering, Log Shipping, and Replication to meet your company's needs
- Understand how to deploy Clustering, Log Shipping, and Replication
- Understand how to deploy Database Mirroring, Database Snapshots, and Partitions.
Want a customized version of this course which will delve more deeply into specific topics of interest in your company? Want a customized version of this course to support current and future high availability initiatives to fast track implementations? Join the dozens of other companies who have selected this option and contact us. We will be more than happy to provide the customized, personalized, private training that you desire.
Instructors
The primary author and primary instructor of this course, Michael Hotek, brings over a decade of practical experience implementing high availability architectures. Mike is an accomplished speaker and trainer having delivered over 100 sessions across dozens of training events spanning more than 8 years with more than 2000 people having attended training from him. He has:
- Installed, configured, and managed hundreds of clusters in every permutation possible
- Designed, implemented, and managed log shipping since before it was given a formal name, dating back to before SQL Server 6.5
- Architected, deployed, and managed hundreds of replication installations spanning tens of thousands of servers in total as well as encompassing each possible replication feature dating back to before replication existed within SQL Server
- Architected and implemented dozens of Enterprise disaster recovery plans
- Performed the hands on recovery of hundreds of operational systems suffering from various failures
- Architected high availability systems across hundreds of companies leveraging a blend of technology with operational process to achieve the best system possible with the technology available
Description
- This is a five-day, skills-based course on Microsoft® SQL Server High Availability (HA) solutions. The course provides SQL Server database administrators with the knowledge and hands-on experience necessary for administering high availability systems.
- This course contains 27 hands on labs to provide experience in all aspects of the technology discussed. 65% of classtime is devoted to hands on labs.
- This course provides you with the technical and business knowledge needed to predictably achieve high availability in a SQL Server environment. The focus of this course is on complete coverage of high availability topics spanning SQL Server 2000 and SQL Server 2005 with a focus on SQL Server 2005, and is not a course on upgrading from SQL Server 2000 to 2005.
- Although some features covered in this course are only available in SQL Server 2005, most topics are relevant to both SQL Server 2000 and SQL Server 2005.
- This course uses Microsoft Virtual Server 2005 with virtual machines equipped with Windows 2003 Enterprise Edition SP2 and SQL Server 2005 Developer Edition SP 2
- This course is available for private onsite classes as well. Request information about onsite private classes using this course.
Audience
This course is intended for DBAs who administer Microsoft SQL Server 2000 database applications and will be migrating to SQL Server 2005. Specific audience segments include:
- Corporate database administrators who need HA information to be more effective in their jobs.
- Service providers and systems integrators tasked with developing and maintaining HA systems (generally with backgrounds in Oracle/UNIX or mainframe/DB2).
- Microsoft technical staff (MCS consultants, technical sales personnel, product support specialists, etc.).
Comments from Attendees
- "Mike's knowledge and the way he presented the labs made this a great course." - 2005 Bellevue, WA
- "Had more hands on than most courses, which I liked" - 2005 Bellevue, WA
- "Just excellent - great opportunity to have access to Mike's expertise" - 2005 Bellevue, WA
Prerequisites
This course requires that students meet the following prerequisites:
- Conversant with hardware terminology and concepts such as RAID and "disk subsystems"
- Proficient with Windows 2000 Advanced Server or Windows 2003 Server Enterprise Edition administration and concepts
- Experience with SQL Server or significant exeperience on Oracle or DB2
- SQL Server 7.0 or 2000 administration experience
Course Objectives
After completing this course, the student will be able to:
- Virtual Server
- Create virtual machines
- Understand disk configurations and resource configuration
- Employ deployment and management best practices
- Manage a simple system failure
- Use backups and data restoration techniques to facilitate disaster recovery
- Plan data restoration
- Describe storage-assisted backup and restore solutions
- Select repair strategies and refine restore sequences
- Design a theoretical solution
- Analyze business requirements
- Apply appropriate technologies and features
- Define high availability (HA)
- Identify Microsoft technologies that can be employed
- Identify administration issues
- Identify design issues (barriers to HA)
- Administer clustered SQL Server instances
- Install and configure a Windows cluster
- Describe clustering technologies supported by Windows 2003 and SQL Server 2005
- Describe how failover clustering functions
- Install and configure a clustered SQL Server 2005 instance
- Implement administrative "best practices" for clustered solutions
- Troubleshoot typical cluster problems
- Implement database mirroring
- Understand how it differs from log shipping and replication
- Plan and configure database mirroring
- Administer database mirroring
- Implement log shipping solutions
- Describe log shipping
- Deploy and manage log shipping
- Implement administrative "best practices" for log shipping
- Plan and configure database snapshots
- Employ database snapshots for recovery
- Describe partitioning technology
- Plan and configure logical partitioning schemes for databases
- Implement partitions
- Employ partitions for manageability
- Implement replication solutions
- Understand replication methods
- Describe how each replication method contributes to an overall solution
- Implement and configure transactional replication
- Implement and configure transactional replication with queued updating subscribers
- Implement and configure transactional replication with immediate updating subscribers
- Implement and configure bi-directional transactional replication
- Implement and configure merge replication
- Implement and configure multi-mode transactional replication
- Implement "best practices" for replication management
Course Outline
- Module 0: Introductions and Course Overview
- Module 1: Overview of High Availability
- Defining High Availability
- Setting Goals and Identifying Barriers
- Microsoft SQL Server 2005 High-Availability Technology
- Evaluating Solutions
- Module 2: Data Restoration
- Problems Addressed by Backups
- Planning for Backup and Restore
- Phases of Restore and Recovery
- Matching Backup Needs to Data-Restoration Needs
- Restore and Recovery
- Device Considerations
- Third-Party Backup Products and SQL Server 2005
- Storage-Assisted Backup and Restore
- Selecting a Repair Strategy
- Lab 1: Configuring a backup strategy
- Lab 2: Restore a file into an active database
- Lab 3: Recover a corrupt page
- Lab 4: Restore from a mirror
- Lab 5: Filegroup backup and restore
- Module 3: SQL Server 2005 Failover Clustering
- Clustering in Windows 2003 and SQL Server 2005
- How Failover Clustering Works
- Installing and Configuring a Clustered Instance
- Applying Best Practices
- Identifying and Troubleshooting Problems in a Clustered Environment
- Lab 6: Install a Windows cluster
- Lab 7: Add resources to an operational cluster
- Lab 8: Add a node to a cluster
- Lab 9: Install a multi-instance SQL Server cluster
- Module 4: Database Mirroring
- Database Mirroring in SQL Server 2005
- Understanding Database Mirroring technology
- How Failover occurs in Database Mirroring
- Managing Failback in Database Mirroring
- Applying Best Practices
- Lab 10: Configuring Database Mirroring
- Lab 11: Simulate failure of principal, mirror, and witness
- Lab 12: Managing application continuance during a failure
- Module 5: SQL Server Log Shipping
- Understanding Log Shipping in SQL Server 2005
- Understanding difference between Database Mirroring and Log Shipping
- Configuring a Log-Shipping Solution
- Applying Best Practices
- Lab 13: Configuring SQL Server Log Shipping from both a cluster and a database mirror
- Lab 14: Simulate failure of primary
- Lab 15: Failback to primary following a failure
- Lab 16: Managing Log Shipping during cluster failover
- Lab 17: Managing Log Shipping during database mirror failover
- Module 6: Database Snapshots
- Understanding SQL Server 2005 Database Snapshots
- Deploying Database Snapshots
- Applying Best Practices for Administrative Tasks
- Lab 18: Configure a database snapshot
- Lab 19: Manage snapshots for reporting
- Lab 20: Data recovery from a snapshot
- Module 7: Partitions
- Understanding partitioning
- Configuring partitions for administrative scenarios
- Lab 21: Data loading using partitions
- Lab 22: Data archival using partitions
- Lab 23: Managing partitions - split and merge
- Module 8: SQL Server Replication
- Understanding SQL Server Replication options
- Describing differences in replication methods
- Configuring Replication
- Lab 24: Transactional replication
- Backup and restore
- Managing failover
- Managing failback
- Managing during mirror failover
- Managing during cluster failover
- Lab 25: Bi-directional replication
- Backup and restore
- Managing failover
- Managing failback
- Managing during mirror failover
- Managing during cluster failover
- Data conflict scenarios
- Lab 26: Peer-to-Peer replication
- Backup and restore
- Managing failover
- Managing failback
- Managing during mirror failover
- Managing during cluster failover
- Lab 27: Merge replication
- Backup and restore
- Managing failover
- Managing failback
- Managing during mirror failover
- Managing during cluster failover
- Data conflict scenarios
- Module 9: Putting It All Together
- Comparison of Technologies
- Where to Get More Information
- Discussion and Wrap-up
|
