Solved

Disk2VHD convert a SQL Server

Posted on 2014-12-23
7
583 Views
Last Modified: 2015-01-09
Hi,

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?
0
Comment
Question by:SvenIA
7 Comments
 
LVL 78

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 125 total points
Comment Utility
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
0
 
LVL 38

Accepted Solution

by:
Philip Elder earned 125 total points
Comment Utility
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.
0
 
LVL 5

Assisted Solution

by:arjunvyavahare
arjunvyavahare earned 125 total points
Comment Utility
Hi,

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.

Regards,
Arjun
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 16

Expert Comment

by:Mike T
Comment Utility
Hi,

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.

Mike
0
 
LVL 30

Assisted Solution

by:pgm554
pgm554 earned 125 total points
Comment Utility
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.

See:
http://technet.microsoft.com/en-us/library/dd758814%28v=sql.100%29.aspx
0
 
LVL 16

Expert Comment

by:Mike T
Comment Utility
Good to know. Thanks :)
0
 
LVL 7

Author Closing Comment

by:SvenIA
Comment Utility
Thanks!
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
First I will try to share a design of a Veeam Backup Infrastructure without Direct NFS Access backup. Note: Direct NFS Access backup transport mechanism is only available in Veeam v9 In above I try to design the Veeam Backup flow between i…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now