build server from scratch

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Database Design » Hardware » build server from scratch

build server from scratch

Rate Topic

Display Mode

Topic Options

Author

Message

curious_sqldba

Posted Sunday, April 15, 2012 4:52 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 4:13 PM
Points: 1,172, Visits: 2,687

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.

Post #1283839

RML51

Posted Monday, April 16, 2012 12:44 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:22 AM
Points: 1,268, Visits: 1,477

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.

Post #1284407

curious_sqldba

Posted Monday, April 16, 2012 1:40 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 4:13 PM
Points: 1,172, Visits: 2,687

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.

Post #1284465

Abel A.

Posted Thursday, July 26, 2012 1:52 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, October 15, 2012 3:07 PM
Points: 15, Visits: 66

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.

Post #1335603

« Prev Topic | Next Topic »

Permissions