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.

Prerequisites

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

Who Should Attend

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

Gedetailleerde cursusinhoud

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