Microsoft SQL Server on NetApp Storage Systems (MSSQL)

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

The following pre-requisites or equivalent knowledge are required for this course:

Data ONTAP Fundamentals (DOTF)

NetApp Protection Software Administration (NPSA)

Data ONTAP SAN Administration (SAN)

At least one of the following:

• Microsoft Course 2072A: Administering a Microsoft SQL Server 2000 Database
• Microsoft Exam 70-228: System Administration for Microsoft SQL Server 2000
• One year of Microsoft SQL Server 2005 experience

At 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® 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® 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

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.