"David Fusfeld" <webmaster at acsysweb dot com> wrote in message
news:%23w%23ROTQnFHA.3336@tk2msftngp13.phx.gbl...
> 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
>

"Geoff N. Hiten" <sqlcraftsman@gmail.com> wrote in message
news:elZdchQnFHA.2484@TK2MSFTNGP15.phx.gbl...
> 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@tk2msftngp13.phx.gbl...
>> 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
>>
>
>

"David Fusfeld" <webmaster at acsysweb dot com> wrote in message
news:OV9mBmQnFHA.4056@TK2MSFTNGP10.phx.gbl...
>I should have added, the hardware I have for the cluster already matches
>the existing server, and the existing server is currently using a SAN
>device. I would just have to do an OS and SQL load on the new server, and
>the SQL upgrade on the existing server.
> Dave
>
>
> "Geoff N. Hiten" <sqlcraftsman@gmail.com> wrote in message
> news:elZdchQnFHA.2484@TK2MSFTNGP15.phx.gbl...
>> 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@tk2msftngp13.phx.gbl...
>>> 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
>>>
>>
>>
>
>

"David Fusfeld" <webmaster at acsysweb dot com> wrote in message
news:%23w%23ROTQnFHA.3336@tk2msftngp13.phx.gbl...
> 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
>