Solved

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

Posted on 2009-04-02
4
1,265 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

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

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

HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
Teach the user how to delpoy the vCenter Server Appliance and how to configure its network settings Deploy OVF: Open VM console and configure networking:
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:

820 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