Description
Duration: 2 days
About this Course
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.
Audience Profile
- NetApp and NetApp Partner Professional Services
- Systems Engineers
- NetApp Customers
At Course Completion
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
Prerequisites
- ONTAP Cluster Administration and ONTAP Data Protection Administration
- SnapCenter Fundamentals WBT
- SnapCenter Administration
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands-on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 9/23/2024 | 9/24/2024 | ||||
| 10/14/2024 | 10/15/2024 | ||||
| 11/4/2024 | 11/5/2024 | ||||
| 11/25/2024 | 11/26/2024 | ||||
| 12/16/2024 | 12/17/2024 | ||||
| 1/6/2025 | 1/7/2025 | ||||
| 1/27/2025 | 1/28/2025 | ||||
| 2/17/2025 | 2/18/2025 | ||||
| 3/10/2025 | 3/11/2025 | ||||
| 3/31/2025 | 4/1/2025 | ||||
| 4/21/2025 | 4/22/2025 | ||||
| 5/12/2025 | 5/13/2025 | ||||
| 6/2/2025 | 6/3/2025 | ||||
| 6/23/2025 | 6/24/2025 | ||||
| 7/14/2025 | 7/15/2025 | ||||
| 8/4/2025 | 8/5/2025 | ||||
| 8/25/2025 | 8/26/2025 | ||||
| 9/15/2025 | 9/16/2025 | ||||
| 10/6/2025 | 10/7/2025 | ||||
| 10/27/2025 | 10/28/2025 | ||||
| 11/17/2025 | 11/18/2025 | ||||
| 12/8/2025 | 12/9/2025 | ||||
| 12/29/2025 | 12/30/2025 | ||||
| 1/19/2026 | 1/20/2026 |
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
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
