dbTalk Databases Forums  

Questions about failover clustering

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Questions about failover clustering in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Christos
 
Posts: n/a

Default Questions about failover clustering - 03-06-2008 , 06:29 AM






Hello all,

I wish to ask two questions about failover (active/passive) SQL 2005
clustering, as some parts are vague about these matters from what I have read
till now.

As I am called to design an appliance of a failover clustering from scratch,
I want first of all to ask about the server hardware. Can I use different
hardware configurations for my clusters? My thoughts are about a 4 proc 32GB
to be my main active configuration, and for a smaller one, 2 proc 32 GB
server to be my failover. It is understandable for me that I will lose
computing power at the time of the failover, but it is acceptable for this to
happen until the hardware of my main node is repaired. The reason for this
is, that it is difficult to explain the existance of a server that will do
nothing (except from clustering) to the finance dept, eventhough there is the
matter of security of the failover required. The articles I have read, do not
forbid the use of different servers with different processors, however, they
do recommend identical servers, and thus, I am a bit confused.

The second question, is if I do need to put first the Windows 2003 in a
cluster as well before the SQL clustering. From what I fathomed, there will
be need of clustering resourses to be used, however, this does not mean
Windows 2003 cluster, just clustering services, right?

Thanks a lot!

Reply With Quote
  #2  
Old   
Kevin3NF
 
Posts: n/a

Default Re: Questions about failover clustering - 03-06-2008 , 07:49 AM






1. If you want to be supported by Microsoft, use an approved Cluster
hardware package from the HCL. The second server is cheap when the main one
goes down and you are losing customers because the passive node is
underpowered.

2. You must build a Windows cluster and have that configured with all the
proper resources before you can install sql server as a virtual (clustered)
instance. MS Cluster service up and running is what determines if SQL
Server needs to be restarted, failed over, etc.

Hope that helps
--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.



"Christos" <Christos (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello all,

I wish to ask two questions about failover (active/passive) SQL 2005
clustering, as some parts are vague about these matters from what I have
read
till now.

As I am called to design an appliance of a failover clustering from
scratch,
I want first of all to ask about the server hardware. Can I use different
hardware configurations for my clusters? My thoughts are about a 4 proc
32GB
to be my main active configuration, and for a smaller one, 2 proc 32 GB
server to be my failover. It is understandable for me that I will lose
computing power at the time of the failover, but it is acceptable for this
to
happen until the hardware of my main node is repaired. The reason for this
is, that it is difficult to explain the existance of a server that will do
nothing (except from clustering) to the finance dept, eventhough there is
the
matter of security of the failover required. The articles I have read, do
not
forbid the use of different servers with different processors, however,
they
do recommend identical servers, and thus, I am a bit confused.

The second question, is if I do need to put first the Windows 2003 in a
cluster as well before the SQL clustering. From what I fathomed, there
will
be need of clustering resourses to be used, however, this does not mean
Windows 2003 cluster, just clustering services, right?

Thanks a lot!



Reply With Quote
  #3  
Old   
Kevin3NF
 
Posts: n/a

Default Re: Questions about failover clustering - 03-06-2008 , 07:49 AM



1. If you want to be supported by Microsoft, use an approved Cluster
hardware package from the HCL. The second server is cheap when the main one
goes down and you are losing customers because the passive node is
underpowered.

2. You must build a Windows cluster and have that configured with all the
proper resources before you can install sql server as a virtual (clustered)
instance. MS Cluster service up and running is what determines if SQL
Server needs to be restarted, failed over, etc.

Hope that helps
--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.



"Christos" <Christos (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello all,

I wish to ask two questions about failover (active/passive) SQL 2005
clustering, as some parts are vague about these matters from what I have
read
till now.

As I am called to design an appliance of a failover clustering from
scratch,
I want first of all to ask about the server hardware. Can I use different
hardware configurations for my clusters? My thoughts are about a 4 proc
32GB
to be my main active configuration, and for a smaller one, 2 proc 32 GB
server to be my failover. It is understandable for me that I will lose
computing power at the time of the failover, but it is acceptable for this
to
happen until the hardware of my main node is repaired. The reason for this
is, that it is difficult to explain the existance of a server that will do
nothing (except from clustering) to the finance dept, eventhough there is
the
matter of security of the failover required. The articles I have read, do
not
forbid the use of different servers with different processors, however,
they
do recommend identical servers, and thus, I am a bit confused.

The second question, is if I do need to put first the Windows 2003 in a
cluster as well before the SQL clustering. From what I fathomed, there
will
be need of clustering resourses to be used, however, this does not mean
Windows 2003 cluster, just clustering services, right?

Thanks a lot!



Reply With Quote
  #4  
Old   
Kevin3NF
 
Posts: n/a

Default Re: Questions about failover clustering - 03-06-2008 , 07:49 AM



1. If you want to be supported by Microsoft, use an approved Cluster
hardware package from the HCL. The second server is cheap when the main one
goes down and you are losing customers because the passive node is
underpowered.

2. You must build a Windows cluster and have that configured with all the
proper resources before you can install sql server as a virtual (clustered)
instance. MS Cluster service up and running is what determines if SQL
Server needs to be restarted, failed over, etc.

Hope that helps
--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.



"Christos" <Christos (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello all,

I wish to ask two questions about failover (active/passive) SQL 2005
clustering, as some parts are vague about these matters from what I have
read
till now.

As I am called to design an appliance of a failover clustering from
scratch,
I want first of all to ask about the server hardware. Can I use different
hardware configurations for my clusters? My thoughts are about a 4 proc
32GB
to be my main active configuration, and for a smaller one, 2 proc 32 GB
server to be my failover. It is understandable for me that I will lose
computing power at the time of the failover, but it is acceptable for this
to
happen until the hardware of my main node is repaired. The reason for this
is, that it is difficult to explain the existance of a server that will do
nothing (except from clustering) to the finance dept, eventhough there is
the
matter of security of the failover required. The articles I have read, do
not
forbid the use of different servers with different processors, however,
they
do recommend identical servers, and thus, I am a bit confused.

The second question, is if I do need to put first the Windows 2003 in a
cluster as well before the SQL clustering. From what I fathomed, there
will
be need of clustering resourses to be used, however, this does not mean
Windows 2003 cluster, just clustering services, right?

Thanks a lot!



Reply With Quote
  #5  
Old   
Kevin3NF
 
Posts: n/a

Default Re: Questions about failover clustering - 03-06-2008 , 07:49 AM



1. If you want to be supported by Microsoft, use an approved Cluster
hardware package from the HCL. The second server is cheap when the main one
goes down and you are losing customers because the passive node is
underpowered.

2. You must build a Windows cluster and have that configured with all the
proper resources before you can install sql server as a virtual (clustered)
instance. MS Cluster service up and running is what determines if SQL
Server needs to be restarted, failed over, etc.

Hope that helps
--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.



"Christos" <Christos (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello all,

I wish to ask two questions about failover (active/passive) SQL 2005
clustering, as some parts are vague about these matters from what I have
read
till now.

As I am called to design an appliance of a failover clustering from
scratch,
I want first of all to ask about the server hardware. Can I use different
hardware configurations for my clusters? My thoughts are about a 4 proc
32GB
to be my main active configuration, and for a smaller one, 2 proc 32 GB
server to be my failover. It is understandable for me that I will lose
computing power at the time of the failover, but it is acceptable for this
to
happen until the hardware of my main node is repaired. The reason for this
is, that it is difficult to explain the existance of a server that will do
nothing (except from clustering) to the finance dept, eventhough there is
the
matter of security of the failover required. The articles I have read, do
not
forbid the use of different servers with different processors, however,
they
do recommend identical servers, and thus, I am a bit confused.

The second question, is if I do need to put first the Windows 2003 in a
cluster as well before the SQL clustering. From what I fathomed, there
will
be need of clustering resourses to be used, however, this does not mean
Windows 2003 cluster, just clustering services, right?

Thanks a lot!



Reply With Quote
  #6  
Old   
Kevin3NF
 
Posts: n/a

Default Re: Questions about failover clustering - 03-06-2008 , 07:49 AM



1. If you want to be supported by Microsoft, use an approved Cluster
hardware package from the HCL. The second server is cheap when the main one
goes down and you are losing customers because the passive node is
underpowered.

2. You must build a Windows cluster and have that configured with all the
proper resources before you can install sql server as a virtual (clustered)
instance. MS Cluster service up and running is what determines if SQL
Server needs to be restarted, failed over, etc.

Hope that helps
--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.



"Christos" <Christos (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello all,

I wish to ask two questions about failover (active/passive) SQL 2005
clustering, as some parts are vague about these matters from what I have
read
till now.

As I am called to design an appliance of a failover clustering from
scratch,
I want first of all to ask about the server hardware. Can I use different
hardware configurations for my clusters? My thoughts are about a 4 proc
32GB
to be my main active configuration, and for a smaller one, 2 proc 32 GB
server to be my failover. It is understandable for me that I will lose
computing power at the time of the failover, but it is acceptable for this
to
happen until the hardware of my main node is repaired. The reason for this
is, that it is difficult to explain the existance of a server that will do
nothing (except from clustering) to the finance dept, eventhough there is
the
matter of security of the failover required. The articles I have read, do
not
forbid the use of different servers with different processors, however,
they
do recommend identical servers, and thus, I am a bit confused.

The second question, is if I do need to put first the Windows 2003 in a
cluster as well before the SQL clustering. From what I fathomed, there
will
be need of clustering resourses to be used, however, this does not mean
Windows 2003 cluster, just clustering services, right?

Thanks a lot!



Reply With Quote
  #7  
Old   
Kevin3NF
 
Posts: n/a

Default Re: Questions about failover clustering - 03-06-2008 , 07:49 AM



1. If you want to be supported by Microsoft, use an approved Cluster
hardware package from the HCL. The second server is cheap when the main one
goes down and you are losing customers because the passive node is
underpowered.

2. You must build a Windows cluster and have that configured with all the
proper resources before you can install sql server as a virtual (clustered)
instance. MS Cluster service up and running is what determines if SQL
Server needs to be restarted, failed over, etc.

Hope that helps
--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.



"Christos" <Christos (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello all,

I wish to ask two questions about failover (active/passive) SQL 2005
clustering, as some parts are vague about these matters from what I have
read
till now.

As I am called to design an appliance of a failover clustering from
scratch,
I want first of all to ask about the server hardware. Can I use different
hardware configurations for my clusters? My thoughts are about a 4 proc
32GB
to be my main active configuration, and for a smaller one, 2 proc 32 GB
server to be my failover. It is understandable for me that I will lose
computing power at the time of the failover, but it is acceptable for this
to
happen until the hardware of my main node is repaired. The reason for this
is, that it is difficult to explain the existance of a server that will do
nothing (except from clustering) to the finance dept, eventhough there is
the
matter of security of the failover required. The articles I have read, do
not
forbid the use of different servers with different processors, however,
they
do recommend identical servers, and thus, I am a bit confused.

The second question, is if I do need to put first the Windows 2003 in a
cluster as well before the SQL clustering. From what I fathomed, there
will
be need of clustering resourses to be used, however, this does not mean
Windows 2003 cluster, just clustering services, right?

Thanks a lot!



Reply With Quote
  #8  
Old   
Kevin3NF
 
Posts: n/a

Default Re: Questions about failover clustering - 03-06-2008 , 07:49 AM



1. If you want to be supported by Microsoft, use an approved Cluster
hardware package from the HCL. The second server is cheap when the main one
goes down and you are losing customers because the passive node is
underpowered.

2. You must build a Windows cluster and have that configured with all the
proper resources before you can install sql server as a virtual (clustered)
instance. MS Cluster service up and running is what determines if SQL
Server needs to be restarted, failed over, etc.

Hope that helps
--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.



"Christos" <Christos (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello all,

I wish to ask two questions about failover (active/passive) SQL 2005
clustering, as some parts are vague about these matters from what I have
read
till now.

As I am called to design an appliance of a failover clustering from
scratch,
I want first of all to ask about the server hardware. Can I use different
hardware configurations for my clusters? My thoughts are about a 4 proc
32GB
to be my main active configuration, and for a smaller one, 2 proc 32 GB
server to be my failover. It is understandable for me that I will lose
computing power at the time of the failover, but it is acceptable for this
to
happen until the hardware of my main node is repaired. The reason for this
is, that it is difficult to explain the existance of a server that will do
nothing (except from clustering) to the finance dept, eventhough there is
the
matter of security of the failover required. The articles I have read, do
not
forbid the use of different servers with different processors, however,
they
do recommend identical servers, and thus, I am a bit confused.

The second question, is if I do need to put first the Windows 2003 in a
cluster as well before the SQL clustering. From what I fathomed, there
will
be need of clustering resourses to be used, however, this does not mean
Windows 2003 cluster, just clustering services, right?

Thanks a lot!



Reply With Quote
  #9  
Old   
Kevin3NF
 
Posts: n/a

Default Re: Questions about failover clustering - 03-06-2008 , 07:49 AM



1. If you want to be supported by Microsoft, use an approved Cluster
hardware package from the HCL. The second server is cheap when the main one
goes down and you are losing customers because the passive node is
underpowered.

2. You must build a Windows cluster and have that configured with all the
proper resources before you can install sql server as a virtual (clustered)
instance. MS Cluster service up and running is what determines if SQL
Server needs to be restarted, failed over, etc.

Hope that helps
--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.



"Christos" <Christos (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello all,

I wish to ask two questions about failover (active/passive) SQL 2005
clustering, as some parts are vague about these matters from what I have
read
till now.

As I am called to design an appliance of a failover clustering from
scratch,
I want first of all to ask about the server hardware. Can I use different
hardware configurations for my clusters? My thoughts are about a 4 proc
32GB
to be my main active configuration, and for a smaller one, 2 proc 32 GB
server to be my failover. It is understandable for me that I will lose
computing power at the time of the failover, but it is acceptable for this
to
happen until the hardware of my main node is repaired. The reason for this
is, that it is difficult to explain the existance of a server that will do
nothing (except from clustering) to the finance dept, eventhough there is
the
matter of security of the failover required. The articles I have read, do
not
forbid the use of different servers with different processors, however,
they
do recommend identical servers, and thus, I am a bit confused.

The second question, is if I do need to put first the Windows 2003 in a
cluster as well before the SQL clustering. From what I fathomed, there
will
be need of clustering resourses to be used, however, this does not mean
Windows 2003 cluster, just clustering services, right?

Thanks a lot!



Reply With Quote
  #10  
Old   
Kevin3NF
 
Posts: n/a

Default Re: Questions about failover clustering - 03-06-2008 , 07:49 AM



1. If you want to be supported by Microsoft, use an approved Cluster
hardware package from the HCL. The second server is cheap when the main one
goes down and you are losing customers because the passive node is
underpowered.

2. You must build a Windows cluster and have that configured with all the
proper resources before you can install sql server as a virtual (clustered)
instance. MS Cluster service up and running is what determines if SQL
Server needs to be restarted, failed over, etc.

Hope that helps
--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.



"Christos" <Christos (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello all,

I wish to ask two questions about failover (active/passive) SQL 2005
clustering, as some parts are vague about these matters from what I have
read
till now.

As I am called to design an appliance of a failover clustering from
scratch,
I want first of all to ask about the server hardware. Can I use different
hardware configurations for my clusters? My thoughts are about a 4 proc
32GB
to be my main active configuration, and for a smaller one, 2 proc 32 GB
server to be my failover. It is understandable for me that I will lose
computing power at the time of the failover, but it is acceptable for this
to
happen until the hardware of my main node is repaired. The reason for this
is, that it is difficult to explain the existance of a server that will do
nothing (except from clustering) to the finance dept, eventhough there is
the
matter of security of the failover required. The articles I have read, do
not
forbid the use of different servers with different processors, however,
they
do recommend identical servers, and thus, I am a bit confused.

The second question, is if I do need to put first the Windows 2003 in a
cluster as well before the SQL clustering. From what I fathomed, there
will
be need of clustering resourses to be used, however, this does not mean
Windows 2003 cluster, just clustering services, right?

Thanks a lot!



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.