Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Live P2V SQL Server


Live P2V SQL Server

Author
Message
sqldriver
sqldriver
Mr or Mrs. 500
Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)

Group: General Forum Members
Points: 564 Visits: 2492
Hello,

Has anyone ever done a live physical to virtual conversion? If so, were there any special considerations or planning steps you took? Did you run into any issues during the process? My plan is going to look something like this:

Audit online data, take down anything unnecessary

Make remaining databases read only

Start 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
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8777 Visits: 16548
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 only

Start 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" ;-)
sqldriver
sqldriver
Mr or Mrs. 500
Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)

Group: General Forum Members
Points: 564 Visits: 2492
I have those steps planned because I've been asked to not shut the server down until the VM is up and running for testing, in case we need to back out/roll back. If we were doing it the 'easy' way I would have just used the wizard :-)

Thanks
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8777 Visits: 16548
wouldnt hurt to try it with the databases read only, good luck

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
sqldriver
sqldriver
Mr or Mrs. 500
Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)

Group: General Forum Members
Points: 564 Visits: 2492
Thanks. I'm still trying to find a thorough checklist for a similar situation. Thankfully this isn't due for a couple days.
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8777 Visits: 16548
See this link

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search