Microsoft SQL Server 2008 R2 810-08230 Benutzerhandbuch
Produktcode
810-08230
Implementing Live Migration for SQL Server 2008 R2
CHAPTER 4
79
11.
From the Virtual Machines section of the results pane in Hyper-V Manager, right-
click the name of the SQL Server VM you just created, and click Connect . The Virtual
Machine Connection tool opens .
Machine Connection tool opens .
12.
In the Action menu in the Virtual Machine Connection window, click Start .
13.
Follow the prompts to install the Windows Server 2008 R2 operating system .
14.
When the operating system installation is complete, install SQL Server 2008 R2 .
Real World
A
fter an operating system is set up, best practice guidelines recommend the
installation of the Hyper-V Integration Services tools for every VM that was
installation of the Hyper-V Integration Services tools for every VM that was
created. The Hyper-V Integration Services tool provides virtual server client (VSC)
code, which ultimately increases Hyper-V performance of the VM from an I/O,
memory management, and network performance perspective. Hyper-V Integration
Services is installed by connecting to the VM and selecting Insert The Integration
Services Setup Disk from the Action Menu of the Virtual Machine Connection win-
dow. Click Install in the AutoPlay dialog box to install the tools.
code, which ultimately increases Hyper-V performance of the VM from an I/O,
memory management, and network performance perspective. Hyper-V Integration
Services is installed by connecting to the VM and selecting Insert The Integration
Services Setup Disk from the Action Menu of the Virtual Machine Connection win-
dow. Click Install in the AutoPlay dialog box to install the tools.
Configuring a SQL Server VM for Live Migration
Organizations interested in using Live Migration need to set up a VM for Live Migration . This
is accomplished by reconfiguring the automatic start action for the VM and then preparing
the VM for high availability by using Failover Cluster Manager . The following steps illustrate
this series of actions in more detail:
is accomplished by reconfiguring the automatic start action for the VM and then preparing
the VM for high availability by using Failover Cluster Manager . The following steps illustrate
this series of actions in more detail:
1.
Create a SQL Server 2008 R2 VM based on the steps in the previous section . Verify that
the VM is using CSV .
2.
In Hyper-V Manager, under Virtual Machines, highlight the VM created in the previ-
ous steps (SQLServer2008R2-VM01 in the example in this chapter) . In the Action pane,
under the VM name, click Settings .
under the VM name, click Settings .
3.
In the left pane, click Automatic Start Action .