Solved

Disk2VHD convert a SQL Server

Posted on 2014-12-23
7
751 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 80

Assisted Solution

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

Accepted Solution

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

Assisted Solution

by:Arjun Vyavahare
Arjun Vyavahare earned 125 total points
ID: 40516204
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 17

Expert Comment

by:Mike T
ID: 40516391
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
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.

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

Expert Comment

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

Author Closing Comment

by:SvenIA
ID: 40540137
Thanks!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
Ransomware is a malware that is again in the list of security  concerns. Not only for companies, but also for Government security and  even at personal use. IT departments should be aware and have the right  knowledge to how to fight it.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

730 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