Solved

Clone VM with Win 2003 Srv and SQL Server 2005 / 2008

Posted on 2009-04-02
4
1,257 Views
Last Modified: 2012-05-06
Hello
We are looking for to build an new ESX Server environment.
The Question now is, if its possible to make some clones from a VM (from a template) with Win 2003 Server and SQL Server 2005 or SQL Server 2008.
I just remember, that it was a problem with SQL Server 2000, something with the Name or SID of the Machine, whitch change while cloning the VM.

Thanks and kind regards
Martin
0
Comment
Question by:Martin Kreis
  • 2
4 Comments
 
LVL 28

Accepted Solution

by:
jhyiesla earned 250 total points
ID: 24049848
Think carefully before you virtualize a SQlL server.  Can it be done... of course. But look at the resources that it uses now and think about the impact on a virtual shared environment.  We have a fairly good size SQL implementation and it's one of a few servers that I will never put into a virtual environment.  SQL will take what ever it's given in terms of resources and even more. If I virtualized our SQL server it would use up so much of the shared resources that one of two things would happen. Either the SQL server performance would suffer because it now has to share everything or all of the other virtual machines would suffer because SQL takes so much... and it would severely limit the number of other servers that I could virtualize.  Everyone's situation is different... but something to think about.
0
 

Author Comment

by:Martin Kreis
ID: 24049994
Performance is not the Problem, we use it for testing and deployment not in a productive environment.
Important for me is, that the cloning is possible without any problems.
0
 
LVL 9

Expert Comment

by:sda100
ID: 24065143
I'm sorry I can't give you an answer on the actual cloning, but in reply to what jhyiesla said, in ESX you can configure resource pools, so you can actually limit the resource of any VM (or group of VMs) you wish.

Steve
0
 
LVL 28

Assisted Solution

by:jhyiesla
jhyiesla earned 250 total points
ID: 24065982
Creating clones in ESX is totally doable.  You can create a VM and then turn it into a template.  From there you can create as many like servers as you need.  I believe that you can also just clone one VM off to make another.  I'm sorry that I don't know the for sure answer to your SQL question.  We have had to move our SQL server around a couple of times to physical servers and it's always worked OK, but the SQL guy has had to go back and reestablish the name and IP when he was done... but again, that's in the physical world.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Will try to explain how to use the VMware feature TAGs in the VMs and create Veeam Backup Jobs using TAGs. Since this article is too long, I will create second article for the Veeam tasks.
HOW TO: Install and Configure VMware vSphere Hypervisor 6.5 (ESXi 6.5), Step by Step Tutorial with screenshots. From Download, Checking Media, to Completed Installation.
Teach the user how to rename, unmount, delete and upgrade VMFS datastores. Open vSphere Web Client: Rename VMFS and NFS datastores: Upgrade VMFS-3 volume to VMFS-5: Unmount VMFS datastore: Delete a VMFS datastore:
Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:

809 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