Protecting SQL Server

Protecting SQL ServerPROTSQLNANetAppNA-PROTSQL1.0In this course, you will learn the following: <ul> <li>Describe the features of the Microsoft SQL Server Plug-in</li><li>List the workflow for using SnapCenter software to protect Microsoft SQL Server databases</li><li>Explain how SnapCenter software uses NetApp technology to protect SQL Server databases</li><li>Illustrate the recommended NetApp storage layouts to support SQL Server data</li><li>Describe data protection strategies for SQL Server databases by using SnapCenter software</li><li>Demonstrate how to configure and perform SQL Server database backups by using SnapCenter software</li><li>Demonstrate SQL Server database restores that use SnapCenter software</li><li>Describe cloning strategies that use SnapCenter software and NetApp technology</li><li>Build alerting and reporting operations for Plug-in for SQL Server</li></ul><ul> <li><a class="fl-href-prod" href="/swisscom/en/course/netapp-ontap9adm"><svg role="img" aria-hidden="true" focusable="false" data-nosnippet class="cms-linkmark"><use xlink:href="/css/img/icnset-linkmarks.svg#linkmark"></use></svg>ONTAP Cluster Administration (ONTAP9ADM) (9.16)</a> and <a class="fl-href-prod" href="/swisscom/en/course/netapp-dataprot9"><svg role="img" aria-hidden="true" focusable="false" data-nosnippet class="cms-linkmark"><use xlink:href="/css/img/icnset-linkmarks.svg#linkmark"></use></svg>ONTAP Data Protection Administration (DATAPROT9) (9.16)</a> or</li><li><a class="fl-href-prod" href="/swisscom/en/course/netapp-cdotdp9"><svg role="img" aria-hidden="true" focusable="false" data-nosnippet class="cms-linkmark"><use xlink:href="/css/img/icnset-linkmarks.svg#linkmark"></use></svg>ONTAP Cluster Administration and Data Protection Bundle (CDOTDP9)</a></li><li>SnapCenter Fundamentals WBT</li><li><a class="fl-href-prod" href="/swisscom/en/course/netapp-scadmin"><svg role="img" aria-hidden="true" focusable="false" data-nosnippet class="cms-linkmark"><use xlink:href="/css/img/icnset-linkmarks.svg#linkmark"></use></svg>SnapCenter Administration (SCADMIN)</a></li></ul><ul> <li>NetApp and NetApp Partner Professional Services</li><li>Systems Engineers</li><li>NetApp Customers</li></ul>Module 1: SnapCenter Plug-In for Microsoft SQL Server Overview <ul> <li>Features</li><li>MS SQL server data protection workflow</li></ul> Module 2: Getting Started with the SnapCenter Plug-In for MS SQL Server <ul> <li>Prerequisite tasks for using the Plug-In</li><li>Installation steps for the Plug-in</li><li>Plug-in configuration</li><li>Storage layout recommendations and restrictions</li><li>Storage design for a virtualized environment</li></ul> Module 3: Data Migration <ul> <li>Resource wizard</li><li>Importing from SnapManager software</li></ul> Module 4: Creating and Backing up SQL Server Resources <ul> <li>Data protection strategy</li><li>Backing up SQL server databases</li></ul> Module 5: Restoring SQL Server Resources <ul> <li>Defining a restore strategy</li><li>Restoring SQL server databases</li></ul> Module 6: Cloning SQL Server Databases <ul> <li>Defining a cloning strategy</li><li>Cloning a SQL server database backup</li><li>Splitting a SQL server cloned database</li><li>Clone lifecycle management</li></ul> Module 7: Monitoring and Managing SQL Server Operations <ul> <li>Monitoring operations</li><li>Canceling a database backup operation</li><li>Monitoring and managing a thin-provisioned environment</li><li>Setting thresholds, alerts and reports</li></ul> Labs: <ul> <li>Configuring SnapCenter and install plug-ins for MS SQL Server</li><li>Migrating databases</li><li>Protecting a MS SQL server database</li><li>Restoring a MS SQL server database</li><li>Cloning a MS SQL server database</li><li>Performing management and monitoring tasks by using SnapCenter software and NetApp ONTAP system manager</li></ul> Appendix A - Challenge labs: <ul> <li>Migrating a database from existing volume to a new volume</li><li>Configuring backup and replication for the newly migrated database</li><li>Configuring a clone lifecycle for the development team</li><li>Performing a point-in-time restore to remove database corruption</li></ul>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- ONTAP Cluster Administration (ONTAP9ADM) (9.16) and ONTAP Data Protection Administration (DATAPROT9) (9.16) or - ONTAP Cluster Administration and Data Protection Bundle (CDOTDP9) - SnapCenter Fundamentals WBT - SnapCenter Administration (SCADMIN)- NetApp and NetApp Partner Professional Services - Systems Engineers - NetApp CustomersModule 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 corruption2 days1800.001800.00900.00900.00900.00900.00900.00900.00900.00900.001800.002340.001011.002022.002670.001900.001900.002224.001800.001735.006250.002224.002224.002224.002224.00232600.0024.0024.0024.0024.0024.0024.0024.0024.0024.0024.0024.0024.00