sqldriver (7/29/2014)
Hello,Has anyone ever done a live physical to virtual conversion?
Yes, more than i care to remember :crazy:
sqldriver (7/29/2014)
If so, were there any special considerations or planning steps you took? Did you run into any issues during the process?
Stop the SQL Server services before starting the P2V, otherwise you may encounter issues when the VM server comes online.
The source servers disk drives are transferred one at a time. In my scenario the data drive image was transferred before the log drive image, consequently the 2 did not match and when the VMs SQL Server services started a large number of the databases failed.
sqldriver (7/29/2014)
Make remaining databases read onlyStart copy only backups with compression to move databases over (we have 3rd party backup software that I don't want to confuse with full backups)
Image physical server
Create VM
Shut down physical machine and change host name
Bring up virtual server and restore databases from backups
I know I have to be missing stuff along the way.
Thanks for any advice
If you shut the instance down first then none of the above will be necessary
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉