TRENDS delivers NetApp courses in partnership with Trainocate - a NetApp Authorized Learning Partner NetApp Logo is a registered trademark of NetApp.

Protecting SQL Server

Schedule

Start End Duration Location Details

Course Details

Protecting SQL Server

Duration: 2 Days

Course Code: PROTSQL

Prerequisite:

•    ONTAP Cluster Administration (ONTAP9ADM) and ONTAP Data Protection Administration (DATAPROT9) or
•    ONTAP Cluster Administration and Data Protection Bundle (CDOTDP9)
•    SnapCenter Fundamentals WBT
•    SnapCenter Administration (SCADMIN)

Course Description:

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.

Course Objective:

This course focuses on enabling you to do 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
 
Intended Audience:

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

Course Outline:

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