Microsoft SQL Server on NetApp Storage Systems (MSSQL)

Course Description Schedule
 
Click on the location to go directly to the booking pageSchedule
Ireland

Currently there are no local training dates scheduled.  To talk to your Account Manager about consultancy options or scheduling further dates, please call +353 1 902 3500 or email enquiries@flane.ie.

United Kingdom
17/09/2012 - 21/09/2012 London, City
This course is guaranteed to run. Please see our complete terms and conditions for full details of this offer.
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.


 

Who should attend

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

Prerequisites

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

Data ONTAP 7-Mode Administration (D7ADM)

NetApp Data Protection Software Administration (NPSA8)

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

Course Objectives

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

Course Content

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.

Duration: 5 days

Price (excl. VAT):
  • 4,500.- €
NetApp Training Units:

60 NTU   NTU's may not have the same redemption value if used in a country other than where they were purchased.