Re: Setting up SQL Server cluster

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: zrb (zrb_at_nospam.net)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 16:26:16 -0500

Can you give some more information on setting up a cheap cluster. I would
love to have one purely for testing and trying out things before I try them
on production.

Regards

Parthi

"Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
news:%23fs6cOeEEHA.684@tk2msftngp13.phx.gbl...
> What is your shared storage system? Your vendor should be providing
cluster
> installation services as part of the cluster sale. Otherwise, it won't be
> certified and it can't be supported.
>
> As a general rule, listen to your vendor, unless what they are saying just
> doesn't make sense. Then check them against what you know and what you
can
> find out (including what you can learn here).
>
> I wish you had asked about this earlier. I would have recommended putting
> together a cheap cluster from a couple of workstations, a pair of SCSI
> cards, and a stand-alone SCSI drive. The cost is relatively low,
especially
> if you use recycled parts, and the learning experience is invaluable.
>
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> I support the Professional Association for SQL Server
> www.sqlpass.org
>
> "Scott" <anonymous@discussions.microsoft.com> wrote in message
> news:840AC18B-9C96-469B-A1C1-27AB8C30E3AB@microsoft.com...
> > Almost everybody might have come accross this situation and handled it
> easily, but we are at the first step in setting up SQL Server cluster. I
am
> contact person for the setup in my organization and I have no idea how to
> set up, and at the same time the NT person is also new to windows
> clustering. We just received the new servers and are just out of the
boxes.
> Obviously we have to start installing NT server some time tomorrow and SQL
> server in the next week. Where should we start. Any suggestions will be
> greatly helpful.
> >
> > Thanks in advance,
> >
> > Scott.
>
>

Relevant Pages

  • Re: Quorum Disk or Majority Node?
    ... LOT of 3rd party applications where every issue is always blamed on ... See "Sizing a Majority Node Set Cluster" ... When SQL Server 2005 starts supporting database mirroring there is ... SQL Server does not NATIVELY support MNS clustering. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Quorum Disk or Majority Node?
    ... Disclaimer: This communication is an original work and represents my sole ... See "Sizing a Majority Node Set Cluster" ... When SQL Server 2005 starts supporting database mirroring there is ... SQL Server does not NATIVELY support MNS clustering. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Automatic failover with SQL Server Standard?
    ... SQL Server 2000 Failover Clustering is NOT supported with SQL Server 2000 Standard Edition. ... You can install and configure any non-cluster aware application as a generic service on a cluster. ... If you have to work with SQL Server 2000 Standard Edition then I would recommend exploring SQL Server Replication. ... Cluster Support Policy ...
    (microsoft.public.sqlserver.clustering)
  • Re: Quorum Disk or Majority Node?
    ... Database Mirroring is already an option. ... See "Sizing a Majority Node Set Cluster" ... When SQL Server 2005 starts supporting database mirroring there is going ... SQL Server does not NATIVELY support MNS clustering. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Now, for the first problem, adding the 3rd node as a member of the cluster. ... You then installed a 2nd instance of SQL Server. ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)