Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

One node SQL cluster

  
   Database Forums (Home) -> Clustering RSS
Next:  Set Default Role Question  
Author Message
gj111

External


Since: Jan 24, 2007
Posts: 3



(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

 >> Stay informed about: One node SQL cluster 
Back to top
Login to vote
Tom Moreau

External


Since: Apr 21, 2004
Posts: 441



(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

 >> Stay informed about: One node SQL cluster 
Back to top
Login to vote
gj111

External


Since: Jan 24, 2007
Posts: 3



(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
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(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
Login to vote
Display posts from previous:   
Related Topics:
4 node cluster - Has anyone set up a 4 node cluster i.e. 3 active and 1 passive ? I only want to consider this as it may reduce cost. We have a lot of servers and the least i want to do is have an active passive 2 node cluster for every server thus doubling the server...

2 node SQL 2005 cluster - I am new to clustering. I will be setting up a 2 node cluster using W2k3 EE and SQL 2005. I have a Dell PE 2850 and Dell PE 1850 for the servers, each containing one 73 GB HD and a PowerVault 220 with 4-73GB HD’s for the shared Drive. I am uncertain...

One node Cluster for SQL 2005 - Hi anyone know if you can cluster sql on a one node cluster in Windows 2003 ? Regards Craig

4 node cluster - I want to set up a 4 node cluster where 3 nodes are active and 1 is the passive node that would take over in case any one of those 3 active nodes fail. How can I set this up ? Any documentation.. Using SQL 2005..

4 Node cluster - We have mix of both SQL 2000 and 2005 enviroments. The push is to consolidate. On 4 node windows 2003 64 bit cluster: Is it possible to host on 2 nodes - SQL 2000 A/A Virtual server and on 3rd and 4th node SQL 2005 A/A vuirtual server? All virtual..
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 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



[ Contact us | Terms of Service/Privacy Policy ]