Re: Upgrade to Cluster

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

Possible, yes. Advisable, no.

Generally, you want a certified cluster solution which is hard to do with an
existing server + a new server + new storage. Clusters expect the hardware
to match exactly. Also, you don't really have a good fallback if the system
goes south during the conversion. If you build a new system, you have an
opportunity to test it out prior to going live. You can run stress tests
and log the performacne metrics to see just how much the system can do. I
have never had much success with in-place upgrades, the sole exception being
replacing cluster nodes with newer ones by adding new members and removing
old ones.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"David Fusfeld" <webmaster at acsysweb dot com> wrote in message
news:%23w%23ROTQnFHA.3336@xxxxxxxxxxxxxxxxxxxxxxx
> Hello all..
> We have a Win2000 Advanced server running SQL 2000 Standard. In order to
> convert this to a clustered setup, is it possible to do an in-place
> upgrade of SQL? What should my steps be to make this a clustered config?
>
> Thanks,
> David Fusfeld
>


.

Relevant Pages

  • Re: N+1 Configuration
    ... Jasper Smith (SQL Server MVP) ... But looking in the cluster admin tool, ... mounting all other drives under that drive ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Question
    ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... Do you want to cluster SQL? ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: Clustering Question
    ... The SQL Cluster would need to be ... SQL will need to Enterprise as well. ... So if I understand you correctly one computer will need Windows Server ...
    (microsoft.public.windows.server.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)
  • Re: Connecting to cluster instance from .NET
    ... I have tried using the SQL 2000 CD and i have ... Virtual IP addresses for the cluster resource groups. ... SQL Server will listen on only those IP addresses ... This is odd because the 172.16 network is a Class B ...
    (microsoft.public.sqlserver.clustering)