how to virtualize sql 2012 on a computer

I am planing to virtualize a computer with sql 2012  and add websites to the computer. I would like to know best practices and how-tos.
pelon_80Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
First you will need to select a Hypervisor OS ?

Will you be using Hyper-V in Wndows 2012 ?
0
pelon_80Author Commented:
Which one should I use?  I want to virtualize a server 2008 R2 to have sql 2012 on it to host a website.
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Do you have a server, which you can use to host the Guest OS?
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

pelon_80Author Commented:
I have Windows Server 2008 R2 Standard with SP1 that I want to use to host sql 2012 to run the website.
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Okay. you can add the Hyper-V role to Windows 2008 R2, but do you use that server, to host any other functions?

e.g. DC, File Server, Exchange Server because it's not recommended.
0
JA ReynoldsIT techCommented:
Maybe this will help... It is the pdf white pages on virtualize a computer with sql 2012  ... it also has the links to grab tools you might need to manage with... Page 45 has some config info and tool links for this project......
Best-Practices-for-Virtualizing-and-Mana
0
pelon_80Author Commented:
I added the Hyper-V role under Program and Features.  Is that a start? We only use the server to host the website.
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
That's a start.....

Now start Hyper-V Manager to create your first virtual server.
0
pelon_80Author Commented:
Can I create a virtual server 2012?
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Yes, you will need to start Hyper-V Manager, Create a virtual machine, and connect the Windows 2012 ISO or DVD Media.

and turn on the VM, and follow the normal installation procedure.
0
pelon_80Author Commented:
How do I know if I have the correct Hyper-V Manager.  When I go to Start>Administrative Tools> Click on Hyper-V Manager all I get under Action is Connect to Server. Is that correct and what do I do from there?
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Connect to you local server....so you can start to manage it.

see here

http://www.tomshardware.co.uk/faq/id-1954347/creating-hyper-virtual-machine-windows-server-2012.html

You have WIndows 2008 R2 ?

You will need this KB from Microsoft

http://support.microsoft.com/kb/2744129

to support Windows 2012 on 2008 R2 Hyper-V
0
pelon_80Author Commented:
I do have windows server 2008 R2 Standard SP1
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Okay, you will need to apply the patch above for Guest Support for Windows 2012.

Start Hyper-V Manager, Connect to your server, Create a VM, Install 2012
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pelon_80Author Commented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Virtualization

From novice to tech pro — start learning today.

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.