Engagement Delivery Guide

High Availability and Disaster Recovery on Microsoft Azure Virtual Machines Jumpstart

Table of Contents

1 Introduction...............................................................................................22 Initiating the Engagement.........................................................................3

2.1 Verifying Readiness for Service.....................................................................32.2 Conducting Internal Pre-Kickoff Meeting........................................................32.3 Customizing the Service and Creating a Baseline Agenda.............................4

3 Engagement Phases..................................................................................53.1 Envision Phase (Kickoff and Scope)...............................................................5

3.1.1 Pre-engagement Information Gathering Phase............................................53.1.2 Kickoff Meeting................................................................................................53.1.3 Environment Review........................................................................................93.1.4 Engagement Schedule.....................................................................................9

3.2 Plan Phase...................................................................................................103.2.1 Information Gathering Interviews................................................................113.2.2 Select HADR and Backup Options................................................................123.2.3 Draft Scenario Report...................................................................................13

3.3 Build Phase..................................................................................................133.3.1 Microsoft Azure Configuration......................................................................133.3.2 Deploying SQL Server infrastructure in Microsoft Azure Virtual Machines

143.3.3 Setup HADR and Backup Scenarios.............................................................14

3.4 Stabilize.......................................................................................................143.5 Closeout Meeting.........................................................................................15

4 References...............................................................................................16

Table 1 - Kickoff Agenda.............................................................................................6Table 2 – Backup Options.........................................................................................12

3

1 IntroductionThe goal of this document is to provide you, the delivery consultant, specific guidance about what is required of you and your customer through the course of the engagement. Successful delivery of these requirements helps verify a successful engagement and value delivered to the customer.The scope of the engagement is limited to a fixed set of activities with variations to the timeline based on complexity and number of workloads defined as in scope during the initial negotiations.

4

2 Initiating the EngagementPrior to engagement kick-off, the delivery consultant should gain familiarity with the state of customer by gathering information from available <Partner> Services.

2.1 Verifying Readiness for ServiceUse the documents included as part of this solution to help you deliver the engagement successfully. List the documents here with descriptions and review them as appropriate:

Statement of Work (SOW) templateUsed to define the scope of the engagement and specify the anticipated activities

Kickoff and closeout presentation templatesMicrosoft Office PowerPoint® templates to support you in conducting effective workshops

Vision and Scope templateTemplate for a <Partner> Services Delivery Methodology (MSDM) Vision and Scope document that you will adapt to the requirements of the specific customer environment

Build GuidesThe build guides and associated scripts that are available for each of the scenarios to accelerate deployment

2.2 Conducting Internal Pre-Kickoff MeetingPrior to meeting the customer, the delivery team should meet to review the customer’s needs and expectations, and the goals of both Microsoft and partners. This meeting is an opportunity for the delivery consultants (technical, business, and operations) to review and discuss existing knowledge and documentation about the customer.Typically, the delivery consultants discuss each others’ skills and suitability for the project. It is essential that these matters are addressed prior to starting the on-site work. The consultants should determine the project agenda and agree on roles and responsibilities for this specific engagement.Additionally, one of the team members must take ownership for arranging the logistics with the customer, including reserving rooms, obtaining audio/visual equipment, setting up building access, providing meals, and securing access to the right staff and information.

5

If the customer is a Premier Services customer, consult with the customer’s Technical Account Manager (TAM) to determine any salient facts that may present risks or opportunities in the implementation of the engagement. If Premier has conducted any recent risk assessments (RAPs) for the customer, those may also provide relevant information.If the Account Technical Strategist or Technical Account Manager has completed an Infrastructure Optimization assessment for the customer, review the results of that assessment and survey.

2.3 Customizing the Service and Creating a Baseline Agenda

The pre-kickoff meeting is the time to agree on the final agenda of the service. Delivery of the engagement depends on the existing customer environment.Once you’ve established the overall engagement flow, you can fill in the baseline agenda with specific activities like workshop sessions, project management meetings, and report authoring.The engagement provides a baseline schedule that must be customized to suit specific customer needs.

Important: Allocate yourself ample time on the schedule for authoring the customer deliverable documents or work products.

Based on the pre-kickoff meeting, the delivery consultant will have enough knowledge to select tools and interviewers when engaging with the customer.The delivery consultant will also have enough knowledge to customize the schedule to suit a specific customer’s needs. This schedule should be confirmed and amended as needed after the kickoff meeting.

6

3 Engagement PhasesUse the information in this section to guide you through the engagement.

3.1 Envision Phase (Kickoff and Scope)3.1.1 Pre-engagement Information Gathering PhaseFor this engagement to be successful, it is vitally important that it is delivered within the context of a specific customer situation and environment and it is essential to find out as much as you can before being on site for the first time. Also be aware that the customer might not be able to answer specific questions for all scenarios appropriately, because of a general lack of understanding of the HADR/Backup options.

Important: Inform the customer of their responsibility of providing a Microsoft Azure subscription with Site to Site VPN connectivity as early as possible. The customer may choose to use an existing subscription or a new one just for this engagement.

The pre-engagement process is critical to confirm that both the client and <Partner> Services have aligned expectations for the engagement. The client should agree to provide a project manager to drive the engagement and help escalate issues to help to find solutions for any problem that could occur. Workloads, duration, and schedule should be discussed during this period.

3.1.2 Kickoff MeetingThe kickoff meeting is an important part of the engagement because it helps both Microsoft and the customer understand what the goals and the scope of the engagement are and what is required to successfully deliver the engagement within the given constraints. You will also discuss logistics for the time you will be on site, specifically regarding the activities that will be taking place and what is required to perform these activities.Make use of the PowerPoint template provided as part of the Offering materials to guide you through the kickoff meeting. Depending on the size of the engagement, two to four hours will be needed for this workshop. The Kickoff presentation is meant to drive conversations, so use it as such rather than quickly flipping through the deck.The agenda for this kickoff meeting (as contained in the PowerPoint template) is:

Introductions

7

ObjectivesReview Challenges/SolutionCurrent Environment & RequirementsEngagement OverviewScope & TimelineRoles & ResponsibilitiesNext Steps and Action ItemsQuestions and Answers

When preparing for this meeting, adapt the following slides to the specific customer situation and engagement:

Table 1 - Kickoff AgendaNo. Slide Title Description1 Kickoff Presentation Add date of presentation.

Consider adding your name and job description.2 Introductions Hide either the “Microsoft” or “Partner” slide and fill it in

appropriately.3 HADR/Backup

ChallengesIf necessary, modify the focus areas for this engagement and add specific items that you will address as part of this engagement (customer pain points).

4 Scope As described in the Statement of Work, add specific activities that you want to highlight as being in or out of scope (to reduce doubt). Because this reflects the Statement of Work, there should be no surprises for the customer on this slide.

5 Offering Activities and Timeline

Adjust the timeline (number of weeks) for the various phases. This is a time boxed 4 week delivery.

6 Schedule and Milestone Using the table provided in the template, indicate a rough schedule with milestones to the customer. It is important for the timetable to highlight customer interaction points and milestones for deliverables.

7 Communication Plan Add specific details to the communications plan, also indicating who will be the primary point of contact for this engagement (you or the EM).

8 Roles and Resources Specify all the resources (from Microsoft and from the customer’s side) that will be part of the engagement. It is advisable to add some contact details for later reference.

9 Next Steps and Action Items

Add some specific action items or next steps you want to highlight to the customer. These action items might be related to the Envision phase deliverables of the answers provided to the questionnaire.

3.1.2.1 Verifying Customer Benefits from EngagementEngage all project stakeholders to confirm that expectations have been correctly set. The whole project team should have an understanding and buy in to the Vision

8

and Scope for this engagement. They should understand the importance of the engagement, as well as how the engagement fits into an overarching program.This discussion should include tangible customer benefits that will be identified by the engagement. Focus on technical, business, and operations aspects as appropriate. Sample items include:

Help me understand my environment.Help me count the number and size of my databases.Help me know if I am following current recommended practices.Help me understand the difference between the options.Help me know if my IT environment is configured appropriately.

When preparing for the engagement, you should consider:What are the key decisions that the customer needs assistance to make?What are the show stoppers that we can resolve?Are there any fundamental knowledge gaps?How can we bring the customer to a solution faster?

3.1.2.2 Assembling the Core Delivery TeamThe engagement is created to be delivered by a virtual team with collective knowledge in, potentially, three disciplines: business value, technical, and operations.The technical part of the engagement can be delivered by one or more consultants skilled enough to perform an audit of the environment by implementing a number of Microsoft and third-party tools, as well as conducting interviews with all relevant stakeholders. This means the customer must provide relevant resources — architect, administrators, and managers — that work with the consultant to achieve these goals.

3.1.2.3 Roles and ResponsibilitiesDuring the project kickoff meeting, it is critical that the roles and responsibilities are clearly defined and agreed to. This is especially important because of the tight timeline and rigid engagement model. At a minimum, the Microsoft consultant should know who the primary point of contact will be while on site to verify the customer is constantly engaged and providing the required information. You must make it clear that the customer’s staff will be asked for assistance during the various activities as well as any interviews that may be required. Make it known that there are deadlines and milestones, specifically around decisions on which databases to use for this engagement and which scenarios the customer wants to see.

9

Similarly, make it clear to the customer who the points of contact will be for this engagement from the Microsoft side and who is responsible for delivering what, as part of the engagement. This should be closely tied to the communication plan that is also agreed as part of the kickoff process.

3.1.2.4 Vision, Scope, and RisksIt is important that the scope of work is reviewed based on the signed work order (WO) and associated statement of work (SOW). A Vision and Scope template has been provided in the offering materials. Use this template to document the scope details.You will need to discuss, agree on, and document what is considered in scope (servers, domains, locations, workloads, applications, operating systems, and hardware) and out of scope for the time that you will be there, because this level of detail is not specified in the SOW. As part of the discussion, make sure that time is spent on identifying potential risks and how those risks can be mitigated. This initial risk assessment should also be documented in the Vision and Scope document.When starting to specify the scope of this engagement, you should now be in agreement with the customer in terms of the following items:

Problem statementCustomer situation (also identifying the business opportunity)Vision and benefitsRequirementsScope (specifying the list of the SQL Server databases\workloads to use)Acceptance and operational criteria (for example, location and equipment)Constraints and risks

These factors are the building blocks for producing the Vision and Scope document for this engagement. This should be a fairly straightforward task due to the fact that this offering is all about analyzing the workloads only, and no changes to the customer IT environment whatsoever are foreseen as deliverables. A template for the Vision and Scope document is provided as part of the offering materials.

3.1.3 Environment ReviewBefore the Vision and Scope is finalized and documented, you should review the current environment and customers processes. It is important to determine if the customer has a current technology road map. Such a map might be implied or explicitly written. The relationship of the customer’s road map to the Microsoft road map should be considered by the

10

delivering consultant. This is particularly true when preparing recommendations as a result of the engagement.This is a good time to review the HADR and backup options and ask the customer to start considering which ones are most relevant to them.The responses to the current environment assessment from the customer are important inputs for the Vision and Scope creation process. Be sure to share all of these documents with the customer after the meeting. Expect this meeting to take two to four hours (depending on the size of the engagement).There are no mandatory deliverables as a result of this exercise.

3.1.4 Engagement ScheduleIt is the EM’s responsibility to discuss this schedule with the customer and get their agreement. Get in touch with the EM to discuss this timetable (especially considering on-site and off-site times and customer touch points) and make sure the customer agrees with your schedule by the end of the first week.

Engagement ScheduleMon Tue Wed Thu Fri

Account Team (work starts two weeks prior to On-site Week 1)

Account Team verifies the customer is ready to start by ensuring a Microsoft Azure subscription is ready to use and that it has VPN connectivity.

On-site Week 1 Kickoff meetingProject preparationStart validation of customer Microsoft Azure environment

Create the initial project planCreate the Conditions of Satisfaction document

Start validation of existing on-premises SQL Server instance.

Complete validation and assessment of on-premises SQL Server instance.

Submit initial project plan, Vision and Scope document, and Conditions of Satisfaction to customer for acceptanceEnd-of-day team meeting

On-site Week 2 Customer status meetingStart identifying databases to be in scope

Continue database identificationStart identifying HADR and backup options for selected databases

Continue identifying HADR and backup options (if needed)Run tools to capture database info (if needed)

Complete activities from previous day

Create draft version scenario report for internal reviewEnd-of-day team meeting

Off-site Week 3 Customer status meeting or conference call

Complete Microsoft Azure configuration

Complete Microsoft Azure Configuration (if needed)Build SQL Server environment and smoke test functionality and connectivity.

11

Mon Tue Wed Thu Fri

Start Microsoft Azure configuration

Review scenario report with customer

Configure SQL Servers (on-premises and in cloud) for HADR and backup scenarios.

On-site Week 4+(size-dependent)

Customer status meeting

Continue with SQL Server environment in Microsoft Azure (if needed)System validation testingAssess the deployed environment with the customerSolution walkthrough

Customer closeout meeting (typically on-site)

3.2 Plan PhaseAfter having agreed on a Vision and Scope document and the engagement schedule with the customer, the selection of databases is started in the Plan phase. In broad terms, the following activities will take place during this phase:

Identify the databases that will be used in the various HADR scenariosReview the HADR and backup options for each of the selected databases.Conduct interviews with individual workload stakeholders.Discuss changes in operational processes as a result of using Microsoft Azure as a backup target and for HADR purposes.If applicable, customer runs non-Microsoft tools to capture inventory of databases and data, and report results to Microsoft.

The output of this phase, as defined in the statement of work (SOW), is:A scenario report outlining the selected databases to be in scope for use in this engagement.

3.2.1 Information Gathering InterviewsDuring interview, you should gather information about the database types, workloads they support, size and tolerable data loss and time. In addition to the technical information, it is important to gather the current processes the customer uses in case of HADR or restoring databases.Some of the technical questions to ask may be:

What is the database used for? Does it need to be synchronized with the application?How large is the database?How often do backups or replication copies need to be taken? This defines the recovery point objective (RPO).What is the acceptable time to restore the database? This defines the recovery time objective (RTO).

12

Operational questions also are a key part of HADR and backup. Some questions may be:

What is the current process to restore a database? For example, does a network operations department initiate or is there a ticketing system used?How are backups and disaster recovery (DR) copies verified or tested?What level of involvement does the workload owner have while the IT department is performing a restore?

People to consider will be:Database and workload owners (IT or business)Business unit IT managers and IT-to-business representatives or liaisonsIT operations (responsible for running and maintaining these servers)IT database administrators (responsible for building and maintaining these workloads)External partners or vendors (operations or development)End users or end-user representatives

Having 1:1 meetings or conference calls with these stakeholder groups will help you in understanding the pain points, implementation details, and business and IT priorities associated with these workloads. When planning and conducting interviews, be sure to consider the following issues:

Prepare an agenda identifying what you expect to get out of this interview well in advance of the actual date and send it out as part of the meeting invite.Make sure the interview partner agrees for you to take notes and send out meeting minutes after the actual interview.Be specific and prepared in terms what kind of information you obtain as part of the interview. Also make note if your interviewee cannot answer specific questions.If you are planning to conduct a lot of interviews, it might pay off to prepare a template form to standardize the note-taking process. Consider using Microsoft OneNote® for doing so.Be sure to add all meeting minutes in the final scenario report in the appendix.

3.2.2 Select HADR and Backup OptionsAfter identifying the databases to use for this engagement, select an appropriate backup option from the table below.

Table 2 – Backup OptionsNo. Backup Options Description1 Backup to Cloud from cloud-

hosted serversThis option uses SQL Server 2014 “Backup to URL” to backup directly to Microsoft Azure Blob storage from servers already in Microsoft Azure Virtual Machines.

2 Backup to Cloud from on- This option uses SQL Server 2014 “Backup to URL” to

13

No. Backup Options Descriptionpremises servers backup directly to Microsoft Azure Blob storage from servers

that are hosted on-premises. VPN connectivity recommended.

3 Use Microsoft Azure Backup Services (for legacy SQL Servers)

This option uses Microsoft Azure Backup Services to move SQL Server backups to Microsoft Azure Blob Storage.

For recent versions of SQL Server (SQL Server 2014 or higher) select option 1 or 2, depending on where the database is hosted.For legacy versions of SQL Server (prior to SQL Server 2014), selection option 3. This option may require some additional configuration in Microsoft Azure.

Select an appropriate HADR option from the table below for other database(s):No. HADR Option Description1 SQL Server 2014 AlwaysOn

Availability Groups for High Availability.

This option shows how to run workloads on SQL Servers 2014 hosted in Microsoft Azure Virtual Machines, while providing high availability and resiliency for applications. Both virtual machines will be hosted in Microsoft Azure and an AlwaysOn Availability Group will be setup in Synchronous-commit mode.

2 SQL Server 2014 AlwaysOn Availability Groups for Disaster Recovery

The option shows how to host a secondary replica in Microsoft Azure for SQL Server 2014 databases running on-premises. An AlwaysOn Availability Group is setup in Asynchronous-commit mode where the primary (and an option secondary) is hosted on-premises while another secondary is hosted in Microsoft Azure.

3 SQL Server Log Shipping for disaster recovery (for legacy versions of SQL Server)

This option is primarily for legacy versions of SQL Server where AlwaysOn cannot be used. In this option, log shipping is used to ship bulk logs to another SQL Server instance in Microsoft Azure. VPN connectivity is required for this setup.

4 SQL Server disaster recovery options for cloud-only.

For workloads that run only in Microsoft Azure, this option provides database-level protection across geographic regions. There are two choice, Database Mirroring and Backup to URL. For Backup to URL, we simply specify the URL to the remote Microsoft Azure datacenter.

3.2.3 Draft Scenario ReportDuring the Plan Phase, it is recommended to create a draft copy of the Scenario Report. The report should indicate at least the following information:

Which options were identified for HADR and BackupWhich databases were identified to setup the chosen optionsList the reasons why each option was chosenDescribe why these options are better than the previous methods that were being usedAny significant change in processes should be listed as well

14

Additional information that can help highlight the benefits on using Microsoft AzureThe report will be completed later and will include the results of testing.

3.3 Build Phase 3.3.1 Microsoft Azure ConfigurationDuring the Build Phase, Microsoft will assist the customer in configuration of the Microsoft Azure subscription as it relates to the SQL Server HADR/Backup scenarios. This may include creating an isolated storage account, a new cloud service, and optionally additional subnets. You should be familiar with performing these tasks using PowerShell.

3.3.2 Deploying SQL Server infrastructure in Microsoft Azure Virtual Machines

Once the draft Scenario Report is completed, it is followed up with guidance on deploying the SQL Server infrastructure in the Microsoft Azure Virtual Machines environmentThe following activities are designated for this stage within the build phase:

Provide guidance on virtual machines and virtual networking with a SQL Server 2014 environment created without customization. Provide assistance in creating a SQL Server 2014 environment with scripts (including customization) and configuring virtual machines.

3.3.3 Setup HADR and Backup ScenariosUse the Build Guides in this offering and accompanying PowerShell scripts to setup the HADR or Backup environment.The output of this phase is an environment that is setup for the HADR and Backup options that were identified.

3.4 StabilizeDuring this phase, Microsoft will assist the customer with the verification of core system functionality. Testing is limited to 4 hours but should encompass the following elements:

Validate connectivity between the customer environment and Microsoft AzureVerify connectivity between customer environment and SQL Server instances in Microsoft AzureVerify basic administrative capabilities of the SQL Server instance

15

Show how the customer can verify the solution is working (this may include PowerShell scripts to show the backup files or using SQL Server Management Studio to look at AlwaysOn monitoring)

Conduct a solution walkthrough, which will serve as the informal knowledge transfer to the customer staff. Illustrate key product capabilities and common administrative tasks, depending on which option was chosen. This is a good time for the customer to get answers to any outstanding questions.While there is no formal output to this phase, the customer should be comfortable that the environment is ready to deploy the solution more broadly and be comfortable in the process.

3.5 Closeout MeetingAt the end of the assignment, there is a closeout meeting to finish the engagement. The closeout meeting is the final activity performed as part the engagement. The findings for the engagement are presented to the customer, and the recommendations are delivered. It is also an opportunity to propose any following engagements that have been identified during this Offering. Topics related to the closeout meeting are:

Meet and discuss:ResultsCloseout, finding, and recommendations presentationFindings related to original objectives and requirementsDiscussion of way to proceed (road map)

Determine customer satisfactionClose engagement

Important: Make sure you identify any possible following engagements for inclusion in the Next Steps section of the presentation.

The closeout meeting is an opportunity to deliver all documentation and reports that resulted from the engagement:

Customer deliverable documentCustomer deliverable presentationCloseout meeting report

16

4 ReferencesSolution Accelerators

Home page for Solution Accelerators on TechNethttp://technet.microsoft.com/en-us/library/cc936627.aspxInfrastructure Planning and Design Guide Serieshttp://technet.microsoft.com/en-us/solutionaccelerators/ee382254.aspx

Solution Accelerators Notifications newsletter subscriptionhttp://technet.microsoft.com/en-us/solutionaccelerators/bb687756.aspx

MAP Online Resources

MAP technical information and download linkshttp://go.microsoft.com/fwlink/?LinkId=106437

Microsoft Assessment and Planning Toolkit on TechNethttp://technet.microsoft.com/en-us/library/bb977556.aspx

17