Protecting SQL Server

Course Content

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