active/passive and active/active

#1

Hi,
I am learning sql server failed over cluster and I got confused that what is
difference between active/passive and active/active when you install sql
server 2005 in cluster server. I read the installation of sql server 2005, I
didn't find where do we need to indicate that. Could somebody give me tips
how to do that?

Thanks,

#2

The Active and Passive terms describe clustering from version 7.0. It does
not apply accurately to SQL 2000/2005/2008. You have clusters with Nodes
(host computers) and Instances (SQL Instances). Since you can have more
than one SQL instance and more than two nodes in a cluster, the proper terms
are Single-Instance and Multi-instance.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

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

Quote:

Hi,
I am learning sql server failed over cluster and I got confused that what
is
difference between active/passive and active/active when you install sql
server 2005 in cluster server. I read the installation of sql server 2005,
I
didn't find where do we need to indicate that. Could somebody give me tips
how to do that?

Thanks,

#3

The Active and Passive terms describe clustering from version 7.0. It does
not apply accurately to SQL 2000/2005/2008. You have clusters with Nodes
(host computers) and Instances (SQL Instances). Since you can have more
than one SQL instance and more than two nodes in a cluster, the proper terms
are Single-Instance and Multi-instance.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

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

Quote:

Hi,
I am learning sql server failed over cluster and I got confused that what
is
difference between active/passive and active/active when you install sql
server 2005 in cluster server. I read the installation of sql server 2005,
I
didn't find where do we need to indicate that. Could somebody give me tips
how to do that?

Thanks,

#4

The Active and Passive terms describe clustering from version 7.0. It does
not apply accurately to SQL 2000/2005/2008. You have clusters with Nodes
(host computers) and Instances (SQL Instances). Since you can have more
than one SQL instance and more than two nodes in a cluster, the proper terms
are Single-Instance and Multi-instance.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

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

Quote:

Hi,
I am learning sql server failed over cluster and I got confused that what
is
difference between active/passive and active/active when you install sql
server 2005 in cluster server. I read the installation of sql server 2005,
I
didn't find where do we need to indicate that. Could somebody give me tips
how to do that?

Thanks,

#5

The Active and Passive terms describe clustering from version 7.0. It does
not apply accurately to SQL 2000/2005/2008. You have clusters with Nodes
(host computers) and Instances (SQL Instances). Since you can have more
than one SQL instance and more than two nodes in a cluster, the proper terms
are Single-Instance and Multi-instance.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

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

Quote:

Hi,
I am learning sql server failed over cluster and I got confused that what
is
difference between active/passive and active/active when you install sql
server 2005 in cluster server. I read the installation of sql server 2005,
I
didn't find where do we need to indicate that. Could somebody give me tips
how to do that?

Thanks,

#6

The Active and Passive terms describe clustering from version 7.0. It does
not apply accurately to SQL 2000/2005/2008. You have clusters with Nodes
(host computers) and Instances (SQL Instances). Since you can have more
than one SQL instance and more than two nodes in a cluster, the proper terms
are Single-Instance and Multi-instance.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

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

Quote:

Hi,
I am learning sql server failed over cluster and I got confused that what
is
difference between active/passive and active/active when you install sql
server 2005 in cluster server. I read the installation of sql server 2005,
I
didn't find where do we need to indicate that. Could somebody give me tips
how to do that?

Thanks,

#7

The Active and Passive terms describe clustering from version 7.0. It does
not apply accurately to SQL 2000/2005/2008. You have clusters with Nodes
(host computers) and Instances (SQL Instances). Since you can have more
than one SQL instance and more than two nodes in a cluster, the proper terms
are Single-Instance and Multi-instance.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

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

Quote:

Hi,
I am learning sql server failed over cluster and I got confused that what
is
difference between active/passive and active/active when you install sql
server 2005 in cluster server. I read the installation of sql server 2005,
I
didn't find where do we need to indicate that. Could somebody give me tips
how to do that?

Thanks,

#8

The Active and Passive terms describe clustering from version 7.0. It does
not apply accurately to SQL 2000/2005/2008. You have clusters with Nodes
(host computers) and Instances (SQL Instances). Since you can have more
than one SQL instance and more than two nodes in a cluster, the proper terms
are Single-Instance and Multi-instance.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

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

Quote:

Hi,
I am learning sql server failed over cluster and I got confused that what
is
difference between active/passive and active/active when you install sql
server 2005 in cluster server. I read the installation of sql server 2005,
I
didn't find where do we need to indicate that. Could somebody give me tips
how to do that?

Thanks,

#9

The Active and Passive terms describe clustering from version 7.0. It does
not apply accurately to SQL 2000/2005/2008. You have clusters with Nodes
(host computers) and Instances (SQL Instances). Since you can have more
than one SQL instance and more than two nodes in a cluster, the proper terms
are Single-Instance and Multi-instance.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

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

Quote:

Hi,
I am learning sql server failed over cluster and I got confused that what
is
difference between active/passive and active/active when you install sql
server 2005 in cluster server. I read the installation of sql server 2005,
I
didn't find where do we need to indicate that. Could somebody give me tips
how to do that?

Thanks,

#10

The Active and Passive terms describe clustering from version 7.0. It does
not apply accurately to SQL 2000/2005/2008. You have clusters with Nodes
(host computers) and Instances (SQL Instances). Since you can have more
than one SQL instance and more than two nodes in a cluster, the proper terms
are Single-Instance and Multi-instance.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

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

Quote:

Hi,
I am learning sql server failed over cluster and I got confused that what
is
difference between active/passive and active/active when you install sql
server 2005 in cluster server. I read the installation of sql server 2005,
I
didn't find where do we need to indicate that. Could somebody give me tips
how to do that?

Thanks,