build server from scratch

  • curious_sqldba

    SSC-Dedicated

    Points: 36262

    I would like to bui a SQL server from scrat.I need some guidance on what softwa I neeed.Mentioned below are my requiremen.

    I) planning to build 2 node sql2008 cluster.

    I need to know what all softwares I need apart from sql server.This would be all on one physical box .I would pref microsoft softwares as I have license for all of those.

  • RML51

    SSCarpal Tunnel

    Points: 4410

    Building a two node cluster on one physical server does not make any sense. The only reason to have a two node cluster is to protect against failiure on one physical server.

  • curious_sqldba

    SSC-Dedicated

    Points: 36262

    RML51 (4/16/2012)


    Building a two node cluster on one physical server does not make any sense. The only reason to have a two node cluster is to protect against failiure on one physical server.

    This is PURELY for a test on my local server( for obvious reasons i dont want to buy two boxes:)). Ofcourse for a prod box i wouldn't built one, however i know companies where they have sort-of clustering within the new VM's.

  • Abel A.

    SSChasing Mays

    Points: 617

    what are your requirements? I run a VM from my laptop and I had no need to purchase a server. I did however built a server for a client which cost just a little over 3k.

    I can't really recommend any hardware solution since I don't know your requirements, but for software...there are many solutions. You can try hyper-v, but windows licenses can be pricey for a test site. I've have ran CentOS+Xen and have nothing but good things to say. I think even xen runs better than hyper-v imo. Hyper-v is very manageable, but has too much overhead. If you're ok with the command line, then go with centos + xen.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply