 |
|
|
|
Next: Clustered SQL server 2005 - Maintenance plan prob..
|
| Author |
Message |
External
Since: Feb 04, 2008
Posts: 2
|
(Msg. 1) Posted: Mon Feb 04, 2008 7:24 am
Post subject: One node SQL cluster
Archived from groups: microsoft>public>sqlserver>clustering (more info?)
|
|
|
Hey guys,
I have a client who would like to install a one node SQL 2005 cluster now
and add a node later when financially feasible. I haven't tried this in the
past and unfortunately don't have any hardware to test with.
Does SQL Server 2005 support the installation of a one node cluster? If so,
is the process of adding a node the same as adding a node to an existing
multi-node SQL cluster? Any gotchas with the install, service pack, etc.
when adding the second node?
Thanks,
Greg |
|
| Back to top |
|
 | |
External
Since: Apr 21, 2004
Posts: 502
|
(Msg. 2) Posted: Mon Feb 04, 2008 10:26 am
Post subject: Re: One node SQL cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Yep. All clusters start as a single node and you add nodes as required.
Check out:
http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlclusters...fault.a
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"gj111" wrote in message
Hey guys,
I have a client who would like to install a one node SQL 2005 cluster now
and add a node later when financially feasible. I haven't tried this in the
past and unfortunately don't have any hardware to test with.
Does SQL Server 2005 support the installation of a one node cluster? If so,
is the process of adding a node the same as adding a node to an existing
multi-node SQL cluster? Any gotchas with the install, service pack, etc.
when adding the second node?
Thanks,
Greg |
|
| Back to top |
|
| |
External
Since: Feb 04, 2008
Posts: 2
|
(Msg. 3) Posted: Mon Feb 04, 2008 10:26 am
Post subject: Re: One node SQL cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Perfect. Thanks Tom.
"Tom Moreau" wrote:
> Yep. All clusters start as a single node and you add nodes as required.
> Check out:
>
> http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlclusters...fault.a
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "gj111" wrote in message
>
> Hey guys,
>
> I have a client who would like to install a one node SQL 2005 cluster now
> and add a node later when financially feasible. I haven't tried this in the
> past and unfortunately don't have any hardware to test with.
>
> Does SQL Server 2005 support the installation of a one node cluster? If so,
> is the process of adding a node the same as adding a node to an existing
> multi-node SQL cluster? Any gotchas with the install, service pack, etc.
> when adding the second node?
>
> Thanks,
> Greg
>
>
>
> >> Stay informed about: One node SQL cluster |
|
| Back to top |
|
| |
External
Since: Jan 10, 2008
Posts: 111
|
(Msg. 4) Posted: Mon Feb 04, 2008 3:24 pm
Post subject: Re: One node SQL cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
And just as a followup,SQL Server is moving to that logic as well. You will
install the bits on all nodes, then configure SQL to operate as a clustered
instance. This is still in the development stage and has not surfaced yet
in a CTP, but it is the intended direction of SQL Clustering.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Tom Moreau" wrote in message
> Yep. All clusters start as a single node and you add nodes as required.
> Check out:
>
> http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlclusters...fault.a
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "gj111" wrote in message
>
> Hey guys,
>
> I have a client who would like to install a one node SQL 2005 cluster now
> and add a node later when financially feasible. I haven't tried this in
> the
> past and unfortunately don't have any hardware to test with.
>
> Does SQL Server 2005 support the installation of a one node cluster? If
> so,
> is the process of adding a node the same as adding a node to an existing
> multi-node SQL cluster? Any gotchas with the install, service pack, etc.
> when adding the second node?
>
> Thanks,
> Greg
>
>
> >> Stay informed about: One node SQL cluster |
|
| Back to top |
|
| |
| Related Topics: | Single node cluster with multiple instances but all as def.. - Hi, I am trying to install multiple SQL 2005 instances onto one machine, which has been configured as a single node cluster. Multiple virtual servers have been created, and I am trying to install one instance onto each virtual server set up for SQL....
3/4 Node Clustering - Hi, We plan to install/setup 3-4 node SQL Clustering using Windows 2003 (Enterprise Edition)/SQL2000 (Enterprise Edition) on SAN (EMC) we plan to initially setup/install clustering using two servers (S1& S2) as an ACTIVE/PASSIVE and then later ad...
CLUSTER NAME - Hi , is there any command to display current cluster name through query . Thanks ARR
Using SQL Mail in a cluster - Hello, I'm trying to set up alerts for jobs and backups, using sql mail. Will this work in a clustered enviroment? if so, can you please forward some information on how to get this set up? thanks in advace. Calvin
Need to add additional NIC to SQL Cluster - Hi We recently built a W2K Advanced server, SQL Ent 2000 cluster. Each node of the cluster had 2 NIC ports: 1 NIC was used for Cross over cable Other NIC was used for LAN. All standard build servers in our environment should have 2 NIC connections -.... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
