Microsoft SQL Server 2005 on NetApp Storage Systems

Course Overview

Learn to design and implement a high-performance, highly available, consolidated Microsoft® SQL Server solution on a NetApp® storage system. This solution-based course focuses on the optimization of Microsoft SQL Server 2005 in a NetApp storage environment. This course takes you through the entire systems integration process of architecture planning, data migration, backup and restore, disaster recovery, and troubleshooting. By the end of this course, you will be able to confidently deploy Microsoft SQL Server on NetApp storage systems.

Booking a Microsoft training course with CourseMonster is as easy as 1 - 2 - 3. Simply click on the date and location that suits you best, confirm your booking and we'll send you all the information that you need.

Related Courses

• Microsoft SQL Server 2005: Updating your Administration Skills to Microsoft SQL Server 2005
• Microsoft SQL Server 2005: Implementing a SQL Server Database (5 day)
• Microsoft SQL Server 2005: MCITP Developer: Designing Server -side Solutions
• Microsoft SQL Server 2005: MCITP Developer: Designing Databases
• Microsoft SQL Server 2005: MCITP Developer: Tuning and Optimising Queries
• Microsoft SQL Server 2005: MCITP Administrator: Designing High Availability Solutions
• Microsoft SQL Server 2005: MCITP Administrator: Administering and Automating Databases and Services
• Microsoft SQL Server 2005: MCITP Administrator: Troubleshooting and Optimising Database Server s
• Microsoft SQL Server 2005: Business Intelligence: Designing a Business Intelligence Solution for the Enterprise
• Microsoft SQL Server 2005: Business Intelligence: Designing an ETL Solution Architecture

Audience

This training is for those who design and deploy NetApp storage systems in a Microsoft SQL Server environment.

Skills Gained

By the end of this course you should be able to:

• Design and implement a high-performance, highly available, consolidated Microsoft SQL Server solution on a NetApp storage system
• Establish a failover cluster on Windows Server 2003 with SnapDrive(R) created iSCSI storage, describe how it works, and discuss its benefits
• Describe how NetApp deployment on a Windows Server 2003 failover cluster differs from NetApp deployment on a Windows Server 2008 failover cluster
• Install and deploy Microsoft SQL Server 2005 and SnapManager(R) 5.0 for SQL Server on a Windows Server 2003 failover cluster where SQL Server data is stored on a NetApp storage system
• Describe how deploying NetApp differs between Microsoft SQL Server 2008 and Microsoft SQL Server 2005 environments
• Create Microsoft SQL Server 2005 database clones for use in test and development environments using SnapManager 5.0 for SQL Server
• Describe and perform the backup and restore process using SnapManager 5.0 for SQL Server
• Describe and implement different disaster recovery methods for a SQL Server and SnapManager solution

Prerequisites

• Data ONTAP (r) Fundamentals (WBT) SAN
• Administration on Data ONTAP 7.3 (ILT)
• NCDA certification
• NCIE-SAN certification
• Minimum one year Microsoft SQL Server administration experience