I remember the old batman shows had a “don’t try this at home” disclaimer after every show, and this came to mind as I started playing with Windows Server 2008, Hyper-V and SQL Server 2008 on my new shuttle PC (4 cores, 8gb RAM, 1TB on three disks)
Here’s what I’ve done
Installed Windows Server 2008 enterprise (you’ll see why in a minute) and added the Hyper-V role and then rebooted.
Added four virtual machines (hence the need for enterprise as it supports four vm’s):
With this rig you can now play with disaster recovery and high availability in SQL Server and work out what’s best for you. For example log ship from the cluster, log ship to the cluster form the mirror, snapshot, and replicate yourself silly.The cost is £1600 for the shuttle and £300 odd (depending on the offer you get) for a Tech|Net subscription so you have the software you need and the knowledge base to use it properly.
I also have to confess I built mine with a lot of help from Daniel Sol (a SQL Server support supremo) so that I can show all of this off at TechEd Barcelona on Monday. If you want to find out more about this and you are going then come along to DAT302, and if you’re not Daniel and I will be showing you how when I get back via a series of blogcasts.
Finally the disclaimers..
PingBack from http://mstechnews.info/2008/10/sql-server-2008-cluster-on-windows-server-2008-in-hyper-v/
If you have a document or links for SQL Server 2008 Cluster on Windows Server 2008 in Hyper-V , can you please send it to me? Kathi2002@rediffmail.com
Thanks Much In Advance
I need it too, please send to firstname.lastname@example.org
This is exactly what I am looking for as well:
"If you have a document or links for SQL Server 2008 Cluster on Windows Server 2008 in Hyper-V , can you please send it to me?"
Please send me a link to any documentation that will allow me to set up a cluster between 2 SQL 2008 servers that are running as Virtual Machines on a Windows Server 2008 server with Hyper-V.
I have scoured the internet for a walkthrough but have come up with nothing.
Thanks in advance,
Could you please send the document. i have a dev server
with windows 2008 and hyper-v
i am planning to do this for my new job search.
Al the best whitepepaer on failover clustering for SQL Server 2008 is form SQL CAT, http://sqlcat.com/whitepapers/archive/2009/07/08/sql-server-2008-failover-clustering.aspx