GB
/
GBP
/
EN_GB

Shaping the future of IT skills

Maximising IT performance through learning

Protecting SQL Server

WGAC-NTP-PROTSQL

NetApp
Open

Protecting SQL Server

21 Jul 2022 - 2 days

English

GMT UTC+00:00

£1,650

Open

Protecting SQL Server

25 Aug 2022 - 2 days

English

EET UTC+02:00

Pricing not available

Open

Protecting SQL Server

03 Oct 2022 - 2 days

English

GMT UTC+00:00

£1,650

Open

Protecting SQL Server

07 Nov 2022 - 2 days

English

EET UTC+02:00

Pricing not available

Open

Protecting SQL Server

21 Dec 2022 - 2 days

English

GMT UTC+00:00

£1,650

Description

Show Tabs
Introduction

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
Prerequisites & Audience
  • and or
  • SnapCenter Fundamentals WBT
Course Benefits

In this course, you will learn 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
Course Topics

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.

NetApp courses


ONTAP Cluster Administration and Data Protection Bundle
CODE: WGAC-NTP-CDOTDP9
Basic NetApp Configuration and Administration
CODE: WGAC-NTP-BNCA
ONTAP Performance Analysis
CODE: WGAC-NTP-PERFCDOT
Configuring and Monitoring NetApp E-Series and EF-Series Storage Systems
CODE: WGAC-NTP-CMESERIES
Automate Storage Administration Using ONTAP REST API and Ansible
CODE: WGAC-NTP-RSTAPI
Integrating Hybrid Clouds with Microsoft Azure
CODE: WGAC-NTP-UNCMMAZ
Protecting SQL Server
CODE: WGAC-NTP-PROTSQL
ONTAP SAN Administration
CODE: WGAC-NTP-SANADM
Implementing VMware vSphere on ONTAP
CODE: WGAC-NTP-IMPVMWAR
StorageGRID Administration
CODE: WGAC-NTP-SGWSADM
ONTAP MetroCluster IP Implementation
CODE: WGAC-NTP-MCCIPIW
SnapCenter Administration
CODE: WGAC-NTP-SCADMIN
Integrating Hybrid Clouds with Amazon Web Services
CODE: WGAC-NTP-INTHCDF
OnCommand Insight: Business Insights
CODE: WGAC-NTP-OCIBI
ONTAP Compliance Solution Administration
CODE: WGAC-NTP-OCSA
ONTAP NFS Administration
CODE: WGAC-NTP-NFSAD
ONTAP SMB Administration
CODE: WGAC-NTP-CIFSAD
OnCommand Insight: Intelligent Operation
CODE: WGAC-NTP-OCIIO
ONTAP Data Protection Administration
CODE: WGAC-NTP-DATAPROT9
ONTAP Cluster Administration
CODE: WGAC-NTP-ONTAP9ADM
ONTAP MetroCluster Installation
CODE: WGAC-NTP-MCCIIW
Administration of Active IQ Unified Manager ONTAP
CODE: WGAC-NTP-AOCMCDOT
We use cookies to understand how you use our site and to improve your experience. To learn more, click here. Read our revised Privacy Policy and Terms and Conditions.