Protecting SQL Server
CODE: NEP_PROTSQL
LENGTH: 16 Hours (2 days)
PRICE: kr24 000,00
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.
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
Audience
- NetApp and NetApp Partner Professional Services
- Systems Engineers
- NetApp Customers
Prerequisites
The following 5 day instructor led class is required..
OT-CLU-DPA - ONTAP Cluster Administration and Data Protection
In addition to the following 3 day instructor led class..
SNAP-C-ADM - NetApp SnapCenter Administration
The SnapCenter Fundamentals free of charge elearning is also required which can be accessed directly from the NetApp Learning Centre. Please contact us for further help as required
Programme
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
Module 3: Data Migration
Module 4: Creating and Backing up SQL Server Resources
Module 5: Restoring SQL Server Resources
Module 6: Cloning SQL Server Databases
Module 7: Monitoring and Managing SQL Server Operations
Labs:
Appendix A - Challenge labs: