• Support Mission Critical Applications

    SQL Server Always On Technologies support mission critical applications with the highest level of availability--because any application downtime can impact your business, resulting in loss of revenue, decreased customer satisfaction, and damage to your company's credibility.

  • Minimize System Downtime

    System downtime occurs for a variety of reasons, such as human error, natural disasters, hardware or software failure, or application upgrades. SQL Server Always On Technologies provide a full range of options to minimize system downtime and maintain appropriate levels of application availability.

  • Full-featured Solution

    Today, SQL Server 2008 Always on Technologies include database mirroring, failover clustering, database snapshots, snapshot isolation, peer-to-peer replication, log shipping, and online operations. Used separately or in combination, these features help minimize downtime and keep critical enterprise systems available.

Audience

This course is intended for IT Professionals who administer and deploy high availability SQL Server solutions in production environments.

Course fee - 200$

For any queries on how to pay, mail us to billing@sqlservermasters.com

Online Payment:

2 Years minimum DBA experience is required.

Hands-on/Lecture Ratio

This class is 80% hands-on, 20% lecture.

Software Needed on Each Student PC

  • Windows Server 2003 or 2008, Windows XP Professional, with at least 1GB RAM
  • SQL Server 2008

High Availability Solutions Contents

Selecting a High Availability Solution

High Availability: Interoperability and Coexistence

  • Database Mirroring and Failover Clustering
  • Database Mirroring and Log Shipping
  • Database Mirroring and Database Snapshots
  • Replication and Log Shipping
  • Replication and Database Mirroring

Log Shipping:

  • Log Shipping Overview
  • Log Shipping Deployment
  • Log Shipping Administration
  • Failing Over to a Log Shipping Secondary
  • Changing Roles Between Primary and Secondary Servers
  • Using Secondary Servers for Query Processing
  • Removing Log Shipping
  • Using Log Shipping as Part of a Recovery Plan
  • Log Shipping Tables and Stored Procedures
  • Monitoring Log Shipping
  • Case studies in log-shipping and troubleshooting

Database Mirroring:

  • Database Mirroring Overview
  • Database Mirroring Sessions
  • Database Mirroring Operating Modes
    • Role Switching During a Database Mirroring Session
    • Automatic Failover
    • Manual Failover
    • Forced Service(With possible Data Loss)
    • Managing Jobs & logins
    • Mirroring States
  • Database Mirroring Deployment
  • Database Mirroring Administration
    • Pausing and Resuming Database Mirroring
    • Removing Database Mirroring
    • Managing Database Mirroring
  • Monitoring Database Mirroring
  • Case studies in Mirroring and troubleshooting

SQL Server Replication

  • Overview
  • Replicating Data Between a Server and Clients
  • Replicating Data in a Server to Server Environment
  • Replication Publishing Model Overview
  • Types of Replication Overview
  • Replication Agents Overview
  • Planning and Architecture (Replication)
  • Physical Architecture
  • How snap shot replication works
  • How transactional replication works
  • How merge replication works
  • Solution Design Considerations
  • Deployment the solution
  • Administering the Replication
  • Maintaining Publications
  • Administering Replication Agents
  • Backing Up and Restoring Replicated Databases
  • Validating Replicated Data
  • Monitoring (Replication)
  • Troubleshooting (Replication)
  • Best Practices for Replication Administration

Clustering SQL server

  • What is a cluster & Overview of Windows Clustering
  • SQL Server Clustering concepts
  • SQL Server Cluster Installation pre-requisites
  • Installing and configuring SQL Server 2005/2008 clustering
  • Installing Services pack & Hot fixes on a cluster
  • Post Installation Steps
  • Cluster administrator
  • Moving Groups between nodes
  • Un-installation of SQL Cluster
  • Case studies in clustering and troubleshooting
  • Best Practices on clustering

After completing this course, students will be able to:

  • How to configure, deploy and maintain all high availability techniques.
  • Fail-over of high availability solution such as log-shipping and mirroring
  • Can able to replicate the data between servers.
  • Configuring the sql server clustering
  • Maintaining the cluster by using cluster admin.