Freigeben über

SQL Server 2008 Cluster on Windows Server 2008 in Hyper-V

  • Artikel

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):

  • W2K8DC is a domain controller with a side serving of ISCSI, so 2 networks will be needed (one external one internal). Leave to install and then add 4 devices (quorum, Data Disk, Log Disk and one for MSDTC).
  • W2K8Node1 Windows Server 2008 and SQL Server 2008 as this isn’t a cluster this a SQL Server cluster (apologies to M&S).
  • Create node 2  like node 1
  • SQL08Demo Another SQL Server virtual machine, but with three instances of SQL Server on it  where they are the principle, mirror and witness.

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..

  • Don’t try this in production
  • No databases were harmed or otherwise corrupted during the making of this demo.

Technorati Tags: slq server 2008,winodws server 2008,hyper-v,virtualisation,clustering,mirroing

Comments

  • Anonymous
    October 30, 2008
    PingBack from http://mstechnews.info/2008/10/sql-server-2008-cluster-on-windows-server-2008-in-hyper-v/

  • Anonymous
    December 08, 2008
    Hi, 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

  • Anonymous
    December 15, 2008
    hi, I need it too, please send to mohamed.fawzy@itworx.com

  • Anonymous
    July 28, 2009
    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, Sunny Rai srai@dapasoft.com

  • Anonymous
    April 16, 2010
    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. srini srikale@gmail.com

  • Anonymous
    April 18, 2010
    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 Andrew