> > > MSSQL Detailed outline

Implementing Microsoft SQL Server 2012 on NetApp Storage Systems (MSSQL)

Course Description Kurs tarihleri Course Outline

Detailed Course Outline

Module 1 Features of Microsoft SQL Server 2012 on Clustered Data ONTAP
  • Describe features of Windows Server 2012
  • Describe features of SQL Server 2012
  • Describe the features and purposes of implementing SQL Server 2012 on clustered Data ONTAP storage
  • Describe the “things-to-do” list and management tools to use for implementing SQL Server on the clustered Data ONTAP operating system

Module 2 Sizing and Preparing Clustered Data ONTAP Storage
  • Size storage requirements based on the fundamentals of SQL Server database infrastructure
  • List the sizing and layout guidelines for SQL Server databases, transaction logs, and SnapInfo directories
  • Create NetApp storage virtual machines (SVMs) for primary and secondary storage
  • Create volumes for the SQL Server databases, transaction logs, and SnapInfo directories

Module 3 Implementing Windows Server Failover Clustering
  • Create a failover cluster
  • Manage failover cluster resources

Module 4 Implementing SnapDrive for Windows and SnapManager for SQL Server
  • Describe NetApp SnapDrive software as a component of the SnapManager for SQL Server (SMSQL) solution
  • Install SnapDrive for Windows
  • Install SnapManager for SQL Server
  • Configure Transport Protocol Settings
  • Configure iSCSI sessions
  • Use SnapDrive on a Windows host to create and connect to LUNs on the storage system

Module 5 Implementing Availability Groups with SnapManager for SQL Server
  • Enable the AlwaysOn Availability Groups feature
  • Use SnapManager for SQL Server (SMSQL) to move databases
  • Use SMSQL to back up databases
  • Use the New Availability Groups Wizard to create availability groups and join secondary replica SQL Server instances

Module 6 Cloning SQL Server Databases with SnapManager for SQL Server
  • Describe database cloning
  • Clone backup sets
  • Clone a production database
  • Clone a database on a SnapMirror destination volume
  • Delete a cloned database

Lab Exercises

Lab 1-1 Explore Windows Server 2012 and OnCommand System Manager
Lab 1-2 Exploring Windows Server Failover Clustering services
Lab 1-3 Explore SQL Server 2012, AdventureWorks, and the AlwaysOn Availability Groups feature
Lab 1-4 Explore PowerShell and PowerShell scripts
Lab 2-1 Determine the space requirements of the SQL1 System and user databases
Lab 2-2 Calculate space requirements and volume layout
Lab 2-3 Create a data Vserver for cluster1
Lab 2-4 Repeat task 3 to create a data Vserver for cluster2
Lab 2-5 Create FlexVol volumes for primary and secondary database storage
Lab 2-6 Create FlexVol volumes for secondary storage
Lab 2-7 Create a CIFS share
Lab 3-1 Use Server Manager to install Windows Server Failover Clustering
Lab 3-2 Use a PowerShell script to install Windows Server Failover Clustering
Lab 3-3 Use Failover Cluster Manager to create a Failover Cluster
Lab 3-4 Use Failover Cluster Manager to add nodes to a Failover Cluster
Lab 4-1 Create a SnapDrive service account
Lab 4-2 (optional)Verify that Windows Server 2012 System prerequisites were met
Lab 4-3 Install SnapDrive for Windows on the SQL Server host
Lab 4-4 Install SMSQL
Lab 4-5 Set up connectivity between SnapDrive and storage virtual machines
Lab 4-6 Establish iSCSI sessions with iSCSI Software Initiator
Lab 4-7 Establish iSCSI sessions with the SnapDrive iSCSI management tool
Lab 4-8 Use SnapDrive for Windows to create disks on SQL1
Lab 4-9 Use SnapDrive for Windows to create disks on SQL2
Lab 4-10 Use SnapDrive for Windows to create disks on SQL3
Lab 5-1 Enable the AlwaysOne Availability Groups feature
Lab 5-2 Move SQL Server database files to NetApp storage
Lab 5-3 Back up the AdventureWorks database with SMSQL (including troubleshooting)
Lab 5-4 Restore the database (including troubleshooting)
Lab 5-5 Create an AlwaysOn availability group
Lab 6-1 Clone a database from a backup set
Lab 6-2 Clone active production databases

 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!