• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 764
  • Last Modified:

p2v SQL server 2005 installed on w2k3 sp2 in to vsphere 4.1 Ent Edition

Hi All,
I have got the P2V migration project using vmware converter cold cloning process using Boot CD. I have got couple of SQL servers in the list to do migration this way. So please let me know the best to do P2V migration for SQL servers.
Just to let you know i have been through lots of info on EE and VMware communities, KB articles about how to do P2V migration using vmwarew converter.
The reason for my post here is specially about SQL server P2V in to vCenter 4.1 hosts Environment.
0
SALinfo
Asked:
SALinfo
  • 5
  • 3
1 Solution
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Stop all the SQL servers on the physical server before you shutdown, before coldclone, and follow Bestways' guide

consult the following guides

Read fellow Expert Bestway's article.
http://www.experts-exchange.com/Software/VMWare/A_3639-VMware-vConverter-P2V-for-Windows-Servers.html

Best Practice Video Guide here
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1004588
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Stop all the SQL Services, and continue as you would a normal server for Coldclone.
0
 
vinitoguptaCommented:
Install the VMWare converter agent on SQL server, stop all the SQL Services and follow the wizard....simple, or other way to build another SQL Server in Virtual world and migrate the databases
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
SALinfoAuthor Commented:
just curious if there is any licensing issue comes in to picture while doing this P2V. I dont think there wil be any, pleasse let me know ur thoughts on this licensing issue.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Other than if it's OEM, licenses are not transferable.
0
 
SALinfoAuthor Commented:
Also while doing P2V using Boot CD as cold cloning, i want to collect the converter logs. It says that these will be collected as Z: in the conversion, but i am not sure of where is that Z: drive going to be. I have checked for it on the Physical server as well as on the Desination VM but couldn't find anywhere. The only way i can find those logs is by importing those logs manually from the vmware converter screen and then importing it to the Source Physical server and then log onto Physical server and copy those logs.
Is this the only way to get those logs or else any other better ways ????
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Normally the Logs from a Cold Conversion are collected on the drive which you map to!

So you would need to map a drive to a network share, and select a drive letter, the Logs are stored on the Network Share.
0
 
SALinfoAuthor Commented:
hanccocka:
Thanks for your response on this, i am not worried about OS licensing and i am asking about SQL server licensing stuff when moved from Source Physical to Destination VM.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
What is you current license per user or per CPU? You should be okay.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now