Microsoft SQL Server on NetApp Storage Systems (MSSQL)

Network Professionals who need to have a working understanding of Microsoft SQL Server 2005 on a NetApp Storage System.

Recommended:

Data ONTAP 7-Mode Administration (D7ADM)

NetApp Data Protection Software Administration (NPSA8)

SAN Administration on Data ONTAP (SAN)

At least one of the following:

• Microsoft course 2072
• Microsoft exam 70-228
• 1 Year of Microsoft SQL Server 2005 experience

On completion of this course the student will be able to:

• Describe the benefits of running SQL Server 2005 on a NetApp Storage System.
• Perform SQL Server 2005 storage planning, implementation and administration.
• Architect a high performance, highly available, consolidated SQL Server solution on a NetApp Storage System.
• Deploy SQL Server 2005 on a NetApp Storage System.
• Describe the SQL Server 2005 backup and restore process using SnapManager.
• Determine the correct NetApp Storage Controller model, volume size and LUN size to support the solution.
• Back up and verify a SQL Server 2005 database using SnapManager.
• Restore data using SnapManager.
• Describe different disaster recovery methods.
• Implement disaster recovery methods.
• Isolate and correct faults in a SQL Server and SnapManager solution.

This solution-based instructor-led course focuses on the optimization of Microsoft SQL Server 2005 in a NetApp storage environment. This course takes students through the entire systems integration process of architecture planning, data migration, backup and restore, disaster recovery and troubleshooting.