Protecting SQL Server

Master the SnapCenter Plug-in for Microsoft SQL Server and empower your database protection skills with our expertly designed course tailored for systems engineers and NetApp professionals.

Course Thumbnail

Essential Skills Gained

Checkmark

Describe features and workflow of SnapCenter for SQL Server.

Checkmark

Configure and perform SQL Server database backups using SnapCenter.

Checkmark

Demonstrate SQL Server database restores with SnapCenter technology.

Checkmark

Implement cloning strategies utilizing SnapCenter and NetApp technologies.

Format

  • Instructor-led
  • 2 days with lectures and hands-on labs.

Audience

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

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. Hands-on exercises provide you with experience in performing these tasks.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

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

  1. Features

  2. MS SQL server data protection workflow

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

  1. Prerequisite tasks for using the Plug-In

  2. Installation steps for the Plug-in

  3. Plug-in configuration

  4. Storage layout recommendations and restrictions

  5. Storage design for a virtualized environment

Module 3: Data Migration

  1. Resource wizard

  2. Importing from SnapManager software

Module 4: Creating and Backing up SQL Server Resources

  1. Data protection strategy

  2. Backing up SQL server databases

Module 5: Restoring SQL Server Resources

  1. Defining a restore strategy

  2. Restoring SQL server databases

Module 6: Cloning SQL Server Databases

  1. Defining a cloning strategy

  2. Cloning a SQL server database backup

  3. Splitting a SQL server cloned database

  4. Clone lifecycle management

Module 7: Monitoring and Managing SQL Server Operations

  1. Monitoring operations

  2. Canceling a database backup operation

  3. Monitoring and managing a thin-provisioned environment

  4. Setting thresholds, alerts and reports

Labs

  1. Configuring SnapCenter and install plug-ins for MS SQL Server

  2. Migrating databases

  3. Protecting a MS SQL server database

  4. Restoring a MS SQL server database

  5. Cloning a MS SQL server database

  6. Performing management and monitoring tasks by using SnapCenter software and NetApp ONTAP system manager

Appendix A - Challenge labs

  1. Migrating a database from existing volume to a new volume

  2. Configuring backup and replication for the newly migrated database

  3. Configuring a clone lifecycle for the development team

  4. Performing a point-in-time restore to remove database corruption

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.