build server from scratch

• curious_sqldba

  SSC-Dedicated

  Points: 36262

  April 15, 2012 at 4:52 pm

  #254097

  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

  April 16, 2012 at 12:44 pm

  #1474294

  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

  April 16, 2012 at 1:40 pm

  #1474347

  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

  July 26, 2012 at 1:52 am

  #1517761

  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.