Re: Cluster Upgrade

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



The easiest way is to upgrade in place. I don't like that technique, so I
usually recommend a two-step upgrade. First, upgrade each node in place to
Windows 2003. Then uninstall SQL from one node, evict it, rebuild it, add
it back to the cluster, and finally re-install SQL and any hotfixes. Repeat
with the other node. That way, you get an upgraded cluster with newly
rebuilt nodes. You can even change the hardware nodes at this time by using
new ones when you replace the original nodes.

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




"Seme Rollansa" <bukusu@xxxxxxxxx> wrote in message
news:OWfS9$6GGHA.3828@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
>
> We have a cluster (2node, 8Way, 8GB) running windows 2000 Advanced. We
> would like to upgrade to windows 2003 Enterprise Edition
>
> Whats the easiest way to accmplish this ? what are the options ? are there
> any links ?
>


.



Relevant Pages

  • RE: MSDE to SQL Server
    ... I understand that you want to upgrade MSDE instances ... We can upgrade the instance SHAREPOINT to SQL and it is not recommended ... Business Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • Re: Upgrade SBS2003 SP2 to R2?
    ... This says that T75-01256 upgrades a Premium to a Premium R2. ... included while Microsoft said that SQL 2005 might be included. ... upgrade SKU, then yes, you get SQL 2005 Workgroup. ... I want to upgrade my SBS 2003 premium to SBS 2003 R2 premium so that I ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL CE 3 and CF 1.0 support
    ... > We have designed our application so that all data access logic is ... > using our automated upgrade mechanism and at the same time upgrade the ... > from the engine download and the database upgrade delay). ... > I also know of applications that have been using SQL CE databases in RAM ...
    (microsoft.public.sqlserver.ce)
  • RE: Migration to SQL 2005 for Workgroups
    ... First I just want to list the detailed upgrade steps for your reference, ... sharepoint will use SQL 2005 instance indeed. ... different mechanism from Microsoft NTBackup to backup Server. ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Install Sql2005 Instance on Cluster
    ... Principal SQL Infrastructure Consultant ... 1>i cannot use the same group iwill have to request new ip /n/w name and disk. ... 2>basically what u are saying is once i upgrade the db to 2k5 threre is no going back, so then there is no point in installing a saperate instnce rather just do inplace upgrade? ... what the client wants to do is install another instance of SQL 2005 on the same virtual server. ...
    (microsoft.public.sqlserver.clustering)