1­-855­-778­-7246
> > > PROTSQL

Protecting SQL Server (PROTSQL)

 

Course Content

This course covers the deployment of the SnapCenter Plug-in for Microsoft SQL Server. In this course, you learn about the features of the plug-in and how to install and perform initial configuration of the plug-in. You learn how to protect, clone, and restore Microsoft SQL Server databases by using SnapCenter software. Through instructor-led presentations, you gain knowledge about these topics. Hands-on exercises provide you with experience in performing these tasks.

Who should attend

  • NetApp and NetApp Partner Professional Services
  • Systems Engineers
  • NetApp Customers

Course Objectives

In this course, you will learn the following:

  • Describe the features of the Microsoft SQL Server Plug-in
  • List the workflow for using SnapCenter software to protect Microsoft SQL Server databases
  • Explain how SnapCenter software uses NetApp technology to protect SQL Server databases
  • Illustrate the recommended NetApp storage layouts to support SQL Server data
  • Describe data protection strategies for SQL Server databases by using SnapCenter software
  • Demonstrate how to configure and perform SQL Server database backups by using SnapCenter software
  • Demonstrate SQL Server database restores that use SnapCenter software
  • Describe cloning strategies that use SnapCenter software and NetApp technology
  • Build alerting and reporting operations for Plug-in for SQL Server

Outline: Protecting SQL Server (PROTSQL)

Module 1: SnapCenter Plug-In for Microsoft SQL Server Overview

  • Features
  • MS SQL server data protection workflow

Module 2: Getting Started with the SnapCenter Plug-In for MS SQL Server

  • Prerequisite tasks for using the Plug-In
  • Installation steps for the Plug-in
  • Plug-in configuration
  • Storage layout recommendations and restrictions
  • Storage design for a virtualized environment

Module 3: Data Migration

  • Resource wizard
  • Importing from SnapManager software

Module 4: Creating and Backing up SQL Server Resources

  • Data protection strategy
  • Backing up SQL server databases

Module 5: Restoring SQL Server Resources

  • Defining a restore strategy
  • Restoring SQL server databases

Module 6: Cloning SQL Server Databases

  • Defining a cloning strategy
  • Cloning a SQL server database backup
  • Splitting a SQL server cloned database
  • Clone lifecycle management

Module 7: Monitoring and Managing SQL Server Operations

  • Monitoring operations
  • Canceling a database backup operation
  • Monitoring and managing a thin-provisioned environment
  • Setting thresholds, alerts and reports

Labs:

  • Configuring SnapCenter and install plug-ins for MS SQL Server
  • Migrating databases
  • Protecting a MS SQL server database
  • Restoring a MS SQL server database
  • Cloning a MS SQL server database
  • Performing management and monitoring tasks by using SnapCenter software and NetApp ONTAP system manager

Appendix A - Challenge labs:

  • Migrating a database from existing volume to a new volume
  • Configuring backup and replication for the newly migrated database
  • Configuring a clone lifecycle for the development team
  • Performing a point-in-time restore to remove database corruption
Classroom Training

Duration 2 days

Price
  • Canada: CAD 2,520
  • NetApp Training Units: 24 NTU
    NTU's may not have the same redemption value if used in a country other than where they were purchased.
Online Training

Duration 2 days

Price
  • Canada: CAD 2,520
  • NetApp Training Units: 24 NTU
    NTU's may not have the same redemption value if used in a country other than where they were purchased.
 
Click on town name to book Schedule
This is an Instructor-Led Classroom course
Fast Lane will carry out all guaranteed training regardless of the number of attendees, exempt from force majeure or other unexpected events, like e.g. accidents or illness of the trainer, which prevent the course from being conducted.
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom.
Canada
Dec 19-20, 2019 Guaranteed to Run Online Training 09:00 Canada/Pacific Enroll
United States
Dec 19-20, 2019 Guaranteed to Run Online Training 09:00 US/Pacific Enroll
Apr 2-3, 2020 Online Training 09:00 US/Central Enroll
Oct 8-9, 2020 Online Training 09:00 US/Central Enroll

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX™ training schedule.

Europe
Germany
Jan 27-28, 2020 Hamburg Enroll
Mar 30-31, 2020 Munich Enroll
Jun 2-3, 2020 Frankfurt Enroll
Jul 27-28, 2020 Berlin Enroll
Sep 28-29, 2020 Stuttgart Enroll
Nov 23-24, 2020 Münster Enroll
United Kingdom
Jan 27-28, 2020 This is a FLEX event Manchester Enroll
Online Training Time zone: Europe/London Enroll
Mar 30-31, 2020 This is a FLEX event London, City Enroll
Online Training Time zone: Europe/London Enroll
Jul 2-3, 2020 This is a FLEX event London, City Enroll
Online Training Time zone: Europe/London Enroll
Aug 25-26, 2020 This is a FLEX event London, City Enroll
Online Training Time zone: Europe/London Enroll
Oct 27-28, 2020 This is a FLEX event London, City Enroll
Online Training Time zone: Europe/London Enroll
 
...