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