Course Title



Fast Start for Microsoft Azure - SQL Server IaaS Workshop Section 4 SQL on Azure HADRInstructor Demo Manual Instructor Edition (Book Title Hidden Style)Conditions and Terms of UseThe contents of this package are for informational and training purposes only and are provided "as is" without warranty of any kind, whether express or implied, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, and non-infringement.Training package content, including URLs and other Internet Web site references, is subject to change without notice. Because Microsoft must respond to changing market conditions, the content should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication. Unless otherwise noted, the companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious, and no association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. ? 2015 Microsoft Corporation. All rights reserved.Copyright and Trademarks? 2015 Microsoft Corporation. All rights reserved.Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual plying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation. For more information, see Use of Microsoft Copyrighted Content at?, Internet Explorer?, and Windows? are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Other Microsoft products mentioned herein may be either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. All other trademarks are property of their respective owners.Contents TOC \o "1-3" \h \z \u Demo 1: AlwaysOn Availability Group PAGEREF _Toc464228851 \h 6Exercise 1: Create AlwaysOn Availability Group PAGEREF _Toc464228852 \h 7Demo 1: AlwaysOn Availability GroupIntroduction This Demo provides guidance on how to use build-in template to create SQL Server AlwaysOn Availability Group in Azure portal. Objectives After completing this Demo, you will be able to:Create AlwaysOn Availability Group using Azure portalScenario The Demo is to use Azure portal to create AlwaysOn Availability Group in Azure resource group.Exercise 1: Create AlwaysOn Availability GroupObjectives In this exercise, we will create SQL Server AlwaysOn Availability Group using template.Task 1: Create AlwaysOn Availability GroupLogin to Azure portalClick on "" to start creating a new resource, type in "AlwaysOn" and press "Enter". Select "SQL Server AlwaysOn Cluster"Note: The other option "SQL Server 2014 AlwaysOn" is for classic model, which is beyond the scope of this demo.This template includes 2 DCs and 2 SQL Server instances with one file share witness for the cluster. Click on "Create" button to continue:In "Basics" section, fill in following parameters:Administrator user namePasswordSubscriptionResource GroupLocationClick on "OK" button to continue once finish:Under "Domain and network setting", fill in following parameters:Domain nameVirtual Network nameDomain Controller subnet nameSQL Server subnet nameClick on "OK" button when readyUnder "Availability group settings", fill in following parameters:Availability group nameAvailability group listener nameAvailability group listener portClick on "OK" button when finish:Under "VM size,storage settings", filling in following parameters:SQL Server virtual machine sizeDomain controller virtual machine sizeFile Share Witness virtual machine sizeSQL Storage accountDC storage AccountSQL Server data disk in TBStorage optimizationClick on "OK" button when ready.Note: Storage optimization has 3 options: General workload, transactional processing, Data warehousing.Under "SQL Server settings", enter following parameters:SQL Server Name PrefixSQL Server versionSQL Server 2012SQL Server 2014SQL Server service account username & PasswordSQL Auto Patching maintenance schedule and starting hourClick on "OK" button when finish:Under "Summary" section, review the parameters. Notice that there is a "Download template" button on the top which allows users to download the JSON template for this configuration. Click on "OK" button when ready.Click "OK" button in "Buy" section to start creating AlwaysOn Availability Group:Wait until AlwaysOn Availability Group is created, this process might take more than one hour to one and half hours007A. When Availability Group is created, you would see the resource group like this: ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download