Disk2VHD convert a SQL Server

Posted on 2014-12-23
Medium Priority
Last Modified: 2015-01-09

I'm trying to convert a Server 2003 with SQL 2005 installed. It doesn't work like the other servers i converted allready. The partition with the SQL logs shows up as corrupted.

How can i convert a SQL Server to Hyper-V succesfully? Do i have to bring the databases down first? And how do i do that?
Question by:SvenIA
LVL 85

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 500 total points
ID: 40515844
you should stop all running processes best to boot from a winpe or other boot disk and then do the disk2vhd otherwise you will have problems
LVL 41

Accepted Solution

Philip Elder earned 500 total points
ID: 40515913
Make sure SQL services and SQL VSS services are stopped prior to running the D2VHD process.

Because D2VHD uses VSS to create the snapshot it will collide with other VSS aware apps such as SQL databases or Exchange databases for example. And yes, this can cause real problems.

Assisted Solution

by:Arjun Vyavahare
Arjun Vyavahare earned 500 total points
ID: 40516204

You can use the same converter but i assume that below is your configuration details of source SQL server -

C: drive - Operating System and SQL Application
D: drive - SQL Database and SQL Logs

Then only convert C: drive and mount in Hyper-V for second D: drive create new hard disk in Hyper-v and manually copy and paste the SQL database and SQL logs

Before performing SQL Database and logs copy paste activity, stop all SQL related services on the server.

I hope this will resolve your issue.

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 19

Expert Comment

by:Mike T
ID: 40516391

You need to stop all SQL services as mentioned above. I like Arjun's answer.
Note, disk2vhd does not work in WinPE though. I thought it would be better too, but it (the tool) doesn't work, so you can only run it within the full OS. I have successfully captured a 2008 server with SQL 2008 installed. Not quite the same as your setup, but the process works on SQL.

LVL 30

Assisted Solution

pgm554 earned 500 total points
ID: 40516956
Just as a FYi,the disk alignment on older versions of Windows and SQL has issues.

I would convert the C drive using disk2vhd ,then create a new D partition and then copy (not convert)those files to the new D drive after you have done an alignment.

LVL 19

Expert Comment

by:Mike T
ID: 40517121
Good to know. Thanks :)

Author Closing Comment

ID: 40540137

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Learn about cloud computing and its benefits for small business owners.
Herein one will find an aggregate of some of my experience building and deploying virtualization stacks both in standalone, clustered Hyper-V, clustered Hyper-V with a Scale-Out File Server (SOFS) backend, and Storage Spaces Direct (S2D).
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question