At the end of last week Microsoft published a useful paper titled: Planning, Implementing and Supporting SQL Server Virtualization with Windows Server 2008 R2 Hyper-V and Live Migration.
The 53-pages document provides guidance for planning and implementing SQL Server 2008 R2 on Hyper-V 2008 R2 virtual machines ready for Live Migration.
It’s divided in four parts that require the use of multiple System Center products such as Virtual Machine Manager (SCVMM) 2008 R2, Configuration Manager (SCCM) 2007 R2, Operations Manager (SCOM) 2007 R2 and Data Protection Manager (SCDPM) 2010:
- Planning (which includes the use of the Microsoft Assessment and Planning (MAP) toolkit)
- Implementation (which includes physical to virtual (P2V) migration of existing physical SQL hosts through SCVMM)
- High Availability and Live Migration
- Ongoing Operations and Support