Avatar of Dan Violet Sagmiller (He/Him)
Dan Violet Sagmiller (He/Him)Flag for United States of America asked on

Setting up an SQL Server Cluster/Farm?

Hello, I plan to purchase and setup Microsoft SQL Server 2008 across multiple machines.  When I worked at MS, they had a server farm setup (that I used, but did not setup) that was a collection of numerous machines, forming one SQL Server.  I'd like to know what versions of 2008 Server, and SQL Server 2008 I need to get to do this (as there are numerous forms of it ranging from 500 to 5000 dollars).

Then what is the overview of configuration/installation options required to set it up, (also leaving it open to add more servers over time.)
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
chapmandew

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
chapmandew

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Dan Violet Sagmiller (He/Him)

We had this up and running internally, but I guess that doesn't mean that it works externally...  grumble.  I think I'll wait for a little bit hoping that someone has a solution that can work through a single connection, or round robin connection array.  (but still only sending the command to a one server, and that takes care of everything.  I don't want redundancy, I want parallel)
SOLUTION
chapmandew

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Dan Violet Sagmiller (He/Him)

Unfortunately, (grumble) I know what you mean.  I guess this is what is needed.  It bothers me that with as much work with shared processing as there is, that databases haven't evolved with it.  At least not on that scale.  

I was hoping for a good answer, but I have to accept truth.  Thanks. :)
chapmandew

I know what you mean.  I think** Oracle adds a layer so that it looks like the db is clustered in such a way, but it just handles the abstraction for you.

There may be some 3rd party software kits out there that handle it for you....not sure though.  Its somewhat of a complicated beast.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes