{"course":{"productid":20788,"modality":1,"active":true,"language":"en","title":"Protecting SQL Server","productcode":"PROTSQL","vendorcode":"NA","vendorname":"NetApp","fullproductcode":"NA-PROTSQL","courseware":{"has_ekit":true,"has_printkit":false,"language":"en"},"url":"https:\/\/portal.flane.ch\/course\/netapp-protsql","objective":"<p>In this course, you will learn the following:<\/p>\n<ul>\n<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>","essentials":"<ul>\n<li><span class=\"cms-link-marked\"><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 <span class=\"fl-prod-pcode\">(ONTAP9ADM)<\/span> (9.16)<\/a><\/span> and <span class=\"cms-link-marked\"><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 <span class=\"fl-prod-pcode\">(DATAPROT9)<\/span> (9.16)<\/a><\/span> or<\/li><li><span class=\"cms-link-marked\"><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 <span class=\"fl-prod-pcode\">(CDOTDP9)<\/span><\/a><\/span><\/li><li>SnapCenter Fundamentals WBT<\/li><li><span class=\"cms-link-marked\"><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 <span class=\"fl-prod-pcode\">(SCADMIN)<\/span><\/a><\/span><\/li><\/ul>","audience":"<ul>\n<li>NetApp and NetApp Partner Professional Services<\/li><li>Systems Engineers<\/li><li>NetApp Customers<\/li><\/ul>","outline":"<p><strong>Module 1: SnapCenter Plug-In for Microsoft SQL Server Overview<\/strong> <\/p>\n<ul>\n<li>Features<\/li><li>MS SQL server data protection workflow<\/li><\/ul><p>\n<strong>Module 2: Getting Started with the SnapCenter Plug-In for MS SQL Server<\/strong><\/p>\n<ul>\n<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><p>\n<strong>Module 3: Data Migration<\/strong><\/p>\n<ul>\n<li>Resource wizard<\/li><li>Importing from SnapManager software<\/li><\/ul><p>\n<strong>Module 4: Creating and Backing up SQL Server Resources<\/strong><\/p>\n<ul>\n<li>Data protection strategy<\/li><li>Backing up SQL server databases<\/li><\/ul><p>\n<strong>Module 5: Restoring SQL Server Resources<\/strong><\/p>\n<ul>\n<li>Defining a restore strategy<\/li><li>Restoring SQL server databases<\/li><\/ul><p>\n<strong>Module 6: Cloning SQL Server Databases<\/strong><\/p>\n<ul>\n<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><p>\n<strong>Module 7: Monitoring and Managing SQL Server Operations<\/strong><\/p>\n<ul>\n<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><p>\n<strong>Labs:<\/strong><\/p>\n<ul>\n<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><p>\n<strong>Appendix A - Challenge labs:<\/strong><\/p>\n<ul>\n<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>","summary":"<p>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.<\/p>","objective_plain":"In this course, you will learn the following:\n\n\n- Describe the features of the Microsoft SQL Server Plug-in\n- List the workflow for using SnapCenter software to protect Microsoft SQL Server databases\n- Explain how SnapCenter software uses NetApp technology to protect SQL Server databases\n- Illustrate the recommended NetApp storage layouts to support SQL Server data\n- Describe data protection strategies for SQL Server databases by using SnapCenter software\n- Demonstrate how to configure and perform SQL Server database backups by using SnapCenter software\n- Demonstrate SQL Server database restores that use SnapCenter software\n- Describe cloning strategies that use SnapCenter software and NetApp technology\n- Build alerting and reporting operations for Plug-in for SQL Server","essentials_plain":"- ONTAP Cluster Administration (ONTAP9ADM) (9.16) and ONTAP Data Protection Administration (DATAPROT9) (9.16) or\n- ONTAP Cluster Administration and Data Protection Bundle (CDOTDP9)\n- SnapCenter Fundamentals WBT\n- SnapCenter Administration (SCADMIN)","audience_plain":"- NetApp and NetApp Partner Professional Services\n- Systems Engineers\n- NetApp Customers","outline_plain":"Module 1: SnapCenter Plug-In for Microsoft SQL Server Overview \n\n\n- Features\n- MS SQL server data protection workflow\n\nModule 2: Getting Started with the SnapCenter Plug-In for MS SQL Server\n\n\n- Prerequisite tasks for using the Plug-In\n- Installation steps for the Plug-in\n- Plug-in configuration\n- Storage layout recommendations and restrictions\n- Storage design for a virtualized environment\n\nModule 3: Data Migration\n\n\n- Resource wizard\n- Importing from SnapManager software\n\nModule 4: Creating and Backing up SQL Server Resources\n\n\n- Data protection strategy\n- Backing up SQL server databases\n\nModule 5: Restoring SQL Server Resources\n\n\n- Defining a restore strategy\n- Restoring SQL server databases\n\nModule 6: Cloning SQL Server Databases\n\n\n- Defining a cloning strategy\n- Cloning a SQL server database backup\n- Splitting a SQL server cloned database\n- Clone lifecycle management\n\nModule 7: Monitoring and Managing SQL Server Operations\n\n\n- Monitoring operations\n- Canceling a database backup operation\n- Monitoring and managing a thin-provisioned environment\n- Setting thresholds, alerts and reports\n\nLabs:\n\n\n- Configuring SnapCenter and install plug-ins for MS SQL Server\n- Migrating databases\n- Protecting a MS SQL server database\n- Restoring a MS SQL server database\n- Cloning a MS SQL server database\n- Performing management and monitoring tasks by using SnapCenter software and NetApp ONTAP system manager\n\nAppendix A - Challenge labs:\n\n\n- Migrating a database from existing volume to a new volume\n- Configuring backup and replication for the newly migrated database\n- Configuring a clone lifecycle for the development team\n- Performing a point-in-time restore to remove database corruption","summary_plain":"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.","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":2,"formatted":"2 days"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":1800},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":1800},"CL":{"country":"CL","currency":"USD","taxrate":19,"price":900},"BR":{"country":"BR","currency":"USD","taxrate":null,"price":900},"CO":{"country":"CO","currency":"USD","taxrate":16,"price":900},"P3":{"country":"P3","currency":"USD","taxrate":null,"price":900},"PA":{"country":"PA","currency":"USD","taxrate":7,"price":900},"PE":{"country":"PE","currency":"USD","taxrate":null,"price":900},"AR":{"country":"AR","currency":"USD","taxrate":21,"price":900},"MX":{"country":"MX","currency":"USD","taxrate":null,"price":900},"FR":{"country":"FR","currency":"EUR","taxrate":19.6,"price":1800},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":2340},"SG":{"country":"SG","currency":"USD","taxrate":8,"price":1011},"US":{"country":"US","currency":"USD","taxrate":null,"price":2022},"CA":{"country":"CA","currency":"CAD","taxrate":null,"price":2670},"NL":{"country":"NL","currency":"EUR","taxrate":21,"price":1900},"BE":{"country":"BE","currency":"EUR","taxrate":21,"price":1900},"SI":{"country":"SI","currency":"USD","taxrate":20,"price":2224},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":1800},"GB":{"country":"GB","currency":"GBP","taxrate":20,"price":1735},"IL":{"country":"IL","currency":"ILS","taxrate":17,"price":6250},"GR":{"country":"GR","currency":"USD","taxrate":null,"price":2224},"MK":{"country":"MK","currency":"USD","taxrate":null,"price":2224},"HU":{"country":"HU","currency":"USD","taxrate":20,"price":2224},"PL":{"country":"PL","currency":"USD","taxrate":23,"price":2224},"RU":{"country":"RU","currency":"RUB","taxrate":18,"price":232600}}},"lastchanged":"2026-02-13T11:31:24+01:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course-schedule\/20788","source_lang":"en","source":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course\/netapp-protsql"}}