Detailed Course 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