Removing Nodes from a Virtual Server?

I've build a SQL 2000 SP3a cluster on top of an 8 node Windows 2003 cluster.
We've decided to split the cluster up into 2 individual clusters and as such
I'm attempting to remove some of the cluster nodes from the Virtual Server
Definiton (as per the "Adding or Removing a Cluster Node from the Vritual
Server Definition" of
http://www.microsoft.com/technet/pro...clus.mspx#EGAA)
Anyway, I begin the SQL install and get to the Computer Name dialog where I
choose the virtual server name. I click next and the install GUI just
disapears. I check and setupsql.exe is continues to show up as running in
Taskman for about 10 minutes then just finishes up.
Any thoughts?
Anyone have any thoughts on this?
"Chris B." wrote:

> I've build a SQL 2000 SP3a cluster on top of an 8 node Windows 2003 cluster.
> We've decided to split the cluster up into 2 individual clusters and as such
> I'm attempting to remove some of the cluster nodes from the Virtual Server
> Definiton (as per the "Adding or Removing a Cluster Node from the Vritual
> Server Definition" of
> http://www.microsoft.com/technet/pro...clus.mspx#EGAA)
> Anyway, I begin the SQL install and get to the Computer Name dialog where I
> choose the virtual server name. I click next and the install GUI just
> disapears. I check and setupsql.exe is continues to show up as running in
> Taskman for about 10 minutes then just finishes up.
> Any thoughts?
|||Hi
Only 4 Nodes are supported on a cluster by SQL Server 2000. It is a setup UI
limitation.
You need to remove the installation like you installed it, with command
line.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:981588B6-717B-45C2-BBBA-F5C30A2AE5F2@.microsoft.com...[vbcol=seagreen]
> Anyone have any thoughts on this?
> "Chris B." wrote:
|||Hmm, thanks for the quick reply.
I don't believe I installed from a command line, but those few weeks were
pretty crazy Can you point me in the general direction of documentation
on the command line syntax? I assume you're talking about using the
sqlrem.bat file?
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Only 4 Nodes are supported on a cluster by SQL Server 2000. It is a setup UI
> limitation.
> You need to remove the installation like you installed it, with command
> line.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:981588B6-717B-45C2-BBBA-F5C30A2AE5F2@.microsoft.com...
>
>
|||I have not seen any. It was in a discussion with a developer from the SQL
Server Development Team.
PSS might be able to help.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:22265BEA-AD19-4C06-BFE6-146D419CCE10@.microsoft.com...[vbcol=seagreen]
> Hmm, thanks for the quick reply.
> I don't believe I installed from a command line, but those few weeks were
> pretty crazy Can you point me in the general direction of
> documentation
> on the command line syntax? I assume you're talking about using the
> sqlrem.bat file?
> "Mike Epprecht (SQL MVP)" wrote:

Removing differential backup

I set up a differential backup on my SQL server and have
decided I would rather not have it. However, I can't seem
to get rid of it. Any suggestions?Hello John
How did you setup the differential backups? Was it setup as a SQLAgent
scheduled job?
If it is setup as a scheduled SQLAgent job, I'm not sure what is preventing
you from disabling/removing the job that performs SQL differential backups.
Could you please elaborate more on what you experience when you try to
disable or delete the job from SQLAgent job list in Enterprise Manager?
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||It was set up through Enterprise Manager by selecting the
database then selecting "all tasks:, I then chose Backup
database then selected Differential Backup. I chose a time
of 3:00 AM.
>--Original Message--
>Hello John
>How did you setup the differential backups? Was it setup
as a SQLAgent
>scheduled job?
>If it is setup as a scheduled SQLAgent job, I'm not sure
what is preventing
>you from disabling/removing the job that performs SQL
differential backups.
>Could you please elaborate more on what you experience
when you try to
>disable or delete the job from SQLAgent job list in
Enterprise Manager?
>Thank you for using Microsoft newsgroups.
>Sincerely
>Pankaj Agarwal
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>.
>|||If you scheduled it there would be a scheduled job that issues the Diff
backup. Simply delete the job. If you didn't schedule a time it would have
been a one shot deal and there is nothing to worry about.
--
Andrew J. Kelly SQL MVP
"John Schuster" <schuster@.llnl.gov> wrote in message
news:043c01c4a0e2$306adfa0$a301280a@.phx.gbl...
> It was set up through Enterprise Manager by selecting the
> database then selecting "all tasks:, I then chose Backup
> database then selected Differential Backup. I chose a time
> of 3:00 AM.
> >--Original Message--
> >Hello John
> >
> >How did you setup the differential backups? Was it setup
> as a SQLAgent
> >scheduled job?
> >If it is setup as a scheduled SQLAgent job, I'm not sure
> what is preventing
> >you from disabling/removing the job that performs SQL
> differential backups.
> >Could you please elaborate more on what you experience
> when you try to
> >disable or delete the job from SQLAgent job list in
> Enterprise Manager?
> >
> >Thank you for using Microsoft newsgroups.
> >
> >Sincerely
> >
> >Pankaj Agarwal
> >Microsoft Corporation
> >
> >This posting is provided AS IS with no warranties, and
> confers no rights.
> >
> >.
> >