Course Overview
SQL Server 2008 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 clustering, log shipping, database mirroring and replication. This course offers enterprise SQL Server administrators the skills to maintain a large number of constantly available database servers.
All of our Microsoft delivery partners providers and specialist Microsoft trainers have met our tough rigorous guidelines and we constantly monitor the quality of our Microsoft training to ensure that your needs are met and only the highest quality Microsoft courses are provided.
Related Courses
Audience
Database administrators, IT managers, network administrators and 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.
Skills Gained
You Will Learn How To
- Leverage SQL Server 2008 technologies to achieve high availability databases
- Design a Service Level Agreement that matches business requirements
- Plan, prepare and install a SQL Server 2008 failover cluster
- Maintain a warm standby server with log shipping
- Mirror a database to ensure disaster recovery
- Employ replication as a high availability solution
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 Outline
High Availability Fundamentals
Characterising high availability
- The "five nines"
- Site
- Instance
- Database
- Defining a Service Level Agreement
Planned vs. unplanned downtime
- Applying service packs
- Performing routine maintenance
- Recovering from disasters
- Handling hardware failures
Installing Failover Clustering
Verifying the Windows cluster
- Failover vs. load balancing
- Running the Cluster Administrator
Planning for SQL Server failover clustering
- Creating the service accounts
- Constructing cluster groups
- Adding groups to nodes
- Local vs. geographically dispersed clusters
Creating a SQL Server cluster
- Specifying the virtual server
- Selecting authentication methods
- Invoking the Cluster Validation Tool
Managing "Always On" Technologies
Backing up and restoring databases
- Compressing backups
- Mirroring backup media
- Performing a page level restore
- Querying partially online databases
Configuring hardware
- RAID
- SAN
- Adding memory or CPUs without downtime
Employing Log Shipping
Preparing for a warm standby server
- Synchronising logins
- Defining 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
Making the case for replication
- Reducing contention for resources
- Providing near real-time data
Laying out a replication strategy
- Analysing topologies
- Local vs. remote distributors
Creating a publication
- Selecting the publishing database and tables
- Choosing the replication type
- Identifying subscribers
- Defining subscriptions
- Configuring publication security
Combining High Availability Techniques
Selecting the appropriate strategies
- Clustering with a mirror
- Log shipping with a cluster
Pulling it all together
- Creating a complete high availability solution
- Evaluating the results
If you would prefer the flexibility of online training, use the link(s) below:
More Online Training>>
