Cluster Upgrade

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 ?
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@.gmail.com> wrote in message
news:OWfS9$6GGHA.3828@.TK2MSFTNGP10.phx.gbl...
> 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 ?
>

Cluster SQL 7.0 in W2KAdv environment

Hi!
This is the scenario:
* Windows 2000 Advanced Server clustered with 2 nodes
After the installation of SQLServer in the first node, does not appear
the 'SQL Server Failover Cluster' or 'Failover Cluster Wizard' in the
program files menu, and the option 'MSDTC Administrative Control' is
in the menu but the file 'dac.exe' isn't installed.
I don't know which is the problem, because the MSDTC resource in the
cluster is on-line and managed by the firt node, after execute the
command comclust. I see the articles in Microsoft KB (290624, 243204,
), but I don't found a solutions. There are a special SQL 7.0 version
for clustering
Thanks!!
Are you sure you installed the Enterprise Edition?
Look at the SQL Server errorlog and verify that you installed the
Enterprise Edition. BAsed on what you are saying about the Failover Wizard
not being there I am thinking that you did not.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I fix this problem by installing the Enterprise Edition (really stupid
), and now the Failover Wizard it's ok, but the 'MSDTC
Administrative Console' still not work. I don't know the reason why
don't install dac.exe. I'll try to install mdac2.8
Thanks for your post.
Regards,
Ren
rboyd@.onlinemicrosoft.com (Rand Boyd [MSFT]) wrote in message news:<CxzmcDlJEHA.4016@.cpmsftngxa10.phx.gbl>...
> Are you sure you installed the Enterprise Edition?
> Look at the SQL Server errorlog and verify that you installed the
> Enterprise Edition. BAsed on what you are saying about the Failover Wizard
> not being there I am thinking that you did not.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.

Cluster File Share failed

I have a Windows 2000 Advanced Server with SQL Server 2000
Enterprise Edition with SP3A. The cluster is set up as a
Active/Active cluster.
What would cause the Cluster File Share resource to fail?
I have a file share directory set up so that if my server
fails over the file share directory 'shot_p' will be
recognized on the failover server.
Event Viewer Error:
Cluster File Share resource 'shot_p' has failed a status
check. The error code is 64.
Thanks,
Mike
Sounds like your network name resource failed...
C:\>net helpmsg 64
The specified network name is no longer available.
C:\>
Regards,
John
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:21aef01c45afe$75b27840$a401280a@.phx.gbl...
> I have a Windows 2000 Advanced Server with SQL Server 2000
> Enterprise Edition with SP3A. The cluster is set up as a
> Active/Active cluster.
> What would cause the Cluster File Share resource to fail?
> I have a file share directory set up so that if my server
> fails over the file share directory 'shot_p' will be
> recognized on the failover server.
> Event Viewer Error:
> Cluster File Share resource 'shot_p' has failed a status
> check. The error code is 64.
> Thanks,
> Mike

Client tools only in SQL 7

How can I install client tools only in SQL 7? Desktop edition and advanced options?If I understand your question, simply insert the CD and run setup... choose
a custom install and select only client connectivity and Tools.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"marijn" <mklijs@.ons.nl> wrote in message
news:d35da914.0307300357.29ec16bb@.posting.google.com...
> How can I install client tools only in SQL 7? Desktop edition and advanced
options?