Specifications
Implementing Live Migration for SQL Server 2008 R2 CHAPTER 4 75
NOTE The Microsoft Assessment and Planning Toolkit can be used to identify whether or
not an organization’s SQL Server systems are good candidates for virtualization. The toolkit
also includes tools for SQL Server inventory, assessments, and intuitive reporting. A down-
load of the Microsoft Assessment and Planning Toolkit is available on the Microsoft Down-
load Center at http://www.microsoft.com/downloads/details.aspx?FamilyID=67240b76-
3148-4e49-943d-4d9ea7f77730&displaylang=en.
Implementing Live Migration for SQL Server 2008 R2
Follow these steps to take advantage of Live Migration for SQL Server 2008 R2 VMs:
1. Ensure that the hardware, software, drivers, and components are supported by
Microsoft and Windows Server 2008 R2.
2. Set up the hardware, shared storage, and networks as recommended in the failover
cluster deployment guides.
NOTE ”Hyper-V: Using Hyper-V and Failover Clustering,” the TechNet article at the
following link, includes step-by-step instructions on how to implement Hyper-V and
failover clustering: http://technet.microsoft.com/en-us/library/cc732181(WS.10).aspx.
In addition to step-by-step instructions on how to implement Hyper-V and failover
clustering, this page also gives information on the requirements for using Hyper-V and
failover clustering, which might be helpful because, the steps in the following sections
assume that a Hyper-V cluster is already in place.
3. For all nodes that you are including in the failover cluster, install Windows Server 2008 R2
(full installation or Server Core installation).
4. Enable the Hyper-V role on each node of the failover cluster.
5. Install the Failover Clustering feature on each node of the failover cluster.
6. Validate the cluster conguration by using the Validate A Conguration Wizard tool
located in Failover Cluster Manager.
7. Congure CSV.
8. Create a SQL Server VM with Hyper-V.
9. Set up a SQL Server VM for Live Migration.
10. Congure cluster networks for Live Migration.