Re: SQL 2008 Cluster - New Installation

Tech-Archive recommends: Fix windows errors by optimizing your registry

Well, although I was not the starter of this thread, I still want to thank
you for this reply. This has been exactly my point several times when I've
been in contact with customers. A cluster may actually lower availability
when not properly used, and as you say you need a test/QA environment. Now I
have one to cower my back next time I run into the discussion on test
environment with one of my customers :)

"Geoff N. Hiten" wrote:

First, I would build a test environment and lear about clustering and its
particular quirks. You will need this anyway for testing patching and
cluster deployment techniques.

Second, clustering is merely one element in a highly available
infrastructure. If you have a cluster and nobody knows how to use it
properly, you can end up lowering the overall system availability instead of
raising it.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"Stuscotland" <Stuscotland@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D0D8F59D-129B-4E28-9258-4972051B06B6@xxxxxxxxxxxxxxxx
Hi
I have a client who wants a new SQL Server 2008 Ent(on Windows 2008
Server)
installation. He wants redundancy so I know we can cluster SQL (2 node?).
I
unfortunately have no knowledge of SQL clustering so would welcome any
suggestions as to what best practice is. I have of course read in-depth
on
the subject but would welcome real-life comment. Any particular
references
to easy--to-follow literature would be greatly appreciated :)

Thanks in advance
--



.

Relevant Pages

  • Re: A complicate cluster configuration...
    ... The SQL Server 2000 EE will be running just in one node, ... It is possible that an operator can manage the cluster from a terminal ... > and SFTPs them to a remote machine. ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... the first instance on the cluster. ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)