Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Live P2V SQL Server Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2014 8:55 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:24 AM
Points: 492, Visits: 2,038
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

Post #1597338
Posted Tuesday, July 29, 2014 9:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 6,751, Visits: 14,395
sqldriver (7/29/2014)
Hello,

Has anyone ever done a live physical to virtual conversion?

Yes, more than i care to remember



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"
Post #1597362
Posted Tuesday, July 29, 2014 9:54 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:24 AM
Points: 492, Visits: 2,038
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
Post #1597375
Posted Tuesday, July 29, 2014 10:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 6,751, Visits: 14,395
wouldnt hurt to try it with the databases read only, good luck

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1597388
Posted Tuesday, July 29, 2014 10:44 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:24 AM
Points: 492, Visits: 2,038
Thanks. I'm still trying to find a thorough checklist for a similar situation. Thankfully this isn't due for a couple days.
Post #1597403
Posted Wednesday, July 30, 2014 1:33 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 6,751, Visits: 14,395
See this link

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1597602
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse