Protecting SQL Server Training (PROTSQL)

Protecting SQL Server Training (PROTSQL)

Print Friendly, PDF & Email

Introduction:

Protecting SQL Server Training (PROTSQL) course with Hands-on Labs (Online, Onsite and Classroom Live)

NetApp Training Units: 24 NTU

This Protecting SQL Server Training (PROTSQL) 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.

Duration: 2 days

Related Courses

Customize It:

  • If you are familiar with some aspects of this Protecting SQL Server Training (PROTSQL) course, we can omit or shorten their discussion.
  • We can adjust the emphasis placed on the various topics or build the Protecting SQL Server Training (PROTSQL) course around the mix of technologies of interest to you (including technologies other than those included in this outline).
  • If your background is nontechnical, we can exclude the more technical topics, include the topics that may be of special interest to you (e.g., as a manager or policy-maker), and present the Protecting SQL Server Training (PROTSQL) course in manner understandable to lay audiences.

Audience / Target Group:

The target audience for this Protecting SQL Server Training (PROTSQL) course:

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

Protecting SQL Server Training (PROTSQL) – Class Prerequisites:

The knowledge and skills that a learner must have before attending this Protecting SQL Server (PROTSQL) course are as follows:

Protecting SQL Server Training (PROTSQL) – Objectives:

Upon completing this Protecting SQL Server (PROTSQL) course, learners will be able to meet these objectives:

  • 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

Protecting SQL Server Training (PROTSQL) – Course Syllabus:

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

Whether you are looking for general information or have a specific question, we want to help!

Request More Information

    Time frame:

    0