SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


build server from scratch


build server from scratch

Author
Message
curious_sqldba
curious_sqldba
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2940 Visits: 3637
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
RML51
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1455 Visits: 1612
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
curious_sqldba
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2940 Visits: 3637
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 boxesSmile). 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.
Abel A.
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search