is there anywhere i can get a step by step order for
installing an active/passive sql2000 cluster on a win2k3
platform that shares an attached san drive. i have not
performed this before and am not sure about how to set up
the san drive. do i set up the disks on one or both
systems. or do i set up the disks on one and run the mscs
setup? any info would be appreciated. thanks.
jay
Strangely enough, BOL (Books On-Line) has a very good set of instructions on
setting up a failover cluster. You start with a working MSCS cluster
(Windows 2003 help files will get you started there).
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"jay mack" <jmack@.thecreek.com> wrote in message
news:00ba01c49c16$eb424960$a501280a@.phx.gbl...
> is there anywhere i can get a step by step order for
> installing an active/passive sql2000 cluster on a win2k3
> platform that shares an attached san drive. i have not
> performed this before and am not sure about how to set up
> the san drive. do i set up the disks on one or both
> systems. or do i set up the disks on one and run the mscs
> setup? any info would be appreciated. thanks.
> jay
|||Hello Jay,
You may find this whitepaper helpful for setting up windows 2003 cluster
Step-by-step instructions for creating and configuring a typical single quorum device multi-node server cluster using a shared disk on servers running the Microsoft Windows Server 2003 Enterprise Edition and
Windows Server 2003 Datacenter Edition operating systems.
http://www.microsoft.com/downloads/d...displaylang=en
For SQL Server 2000 clustering, the following Microsoft Whitepaper is good
http://www.microsoft.com/technet/pro.../failclus.mspx
This whitepaper was released before Win2K3 and does not discuss about it. Although most of the things are same for SQL 2K Failover cluster on Win2K3, here are some things that are different/unsupported:
Installation of a Named Instance of SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails
http://support.microssoft.com/?id=815431
SQL Server 2000 Cluster Does Not Install on Windows Server 2003-Based Computers Where Terminal Services Is Installed
http://support.microsoft.com/?id=301520
SQL Server 2000 Is Not Supported on Windows Server 2003 Terminal Server Application Server
http://support.microsoft.com/?id=327270
Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight Nodes
http://support.microsoft.com/?id=811054
SQL Server 2000 support for mounted volumes
http://support.microsoft.com/?id=819546
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
Showing posts with label san. Show all posts
Showing posts with label san. Show all posts
Thursday, March 22, 2012
Active/Active/Active without SAN
I read that its possible to implement an Active/Active/Active with SQL 2000
on Win Server 2003 Ent without SAN but could not find a good step by step
howtos to it.
Could some kind gentlemen point me to a good article ? please and thanks in
advance.
SCSI clusters only support two nodes. As far as Active/Active/Active
terminology, that really doesn't express what your intent is. The new
terminology is Multi-instance and you need to state how many nodes and SQL
instances you are trying to build in your cluster. I.E I want to build a
four node cluster with three SQL instances.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lewis" <Lewis@.discussions.microsoft.com> wrote in message
news:3C882765-40EE-424E-8BEF-A5F768D2207D@.microsoft.com...
>I read that its possible to implement an Active/Active/Active with SQL 2000
> on Win Server 2003 Ent without SAN but could not find a good step by step
> howtos to it.
> Could some kind gentlemen point me to a good article ? please and thanks
> in
> advance.
|||My setup is a 2 data center, 2 server in location and 1 single in another. I
would like to implement a fail safe SQL system. So this will be a 3 node
system and I am intending that at any single update to database, all 3 will
be updated instantly. Because its not in the same datacenter, therefore
implementing a SAN is not possible, so with this in mind can my original
question be possible and is there any Howtos document to follow.. appreciate
any assistance.
"Geoff N. Hiten" wrote:
> SCSI clusters only support two nodes. As far as Active/Active/Active
> terminology, that really doesn't express what your intent is. The new
> terminology is Multi-instance and you need to state how many nodes and SQL
> instances you are trying to build in your cluster. I.E I want to build a
> four node cluster with three SQL instances.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Lewis" <Lewis@.discussions.microsoft.com> wrote in message
> news:3C882765-40EE-424E-8BEF-A5F768D2207D@.microsoft.com...
>
>
|||What you are asking about is a Geo-cluster or a geographically separated
cluster. NSI makes some products that can give you this functionality. Some
SAN vendors also handle SAN-level data replication for disaster
recovery/fault tolerance setups. There are no built-in features in SQL
Server 2000 to allow what you are asking for. SQL Server 2005 adds a new
technology called Database Mirroring that allows you to build a multi-site
high-availability solution.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lewis" <Lewis@.discussions.microsoft.com> wrote in message
news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@.microsoft.com...[vbcol=seagreen]
> My setup is a 2 data center, 2 server in location and 1 single in another.
> I
> would like to implement a fail safe SQL system. So this will be a 3 node
> system and I am intending that at any single update to database, all 3
> will
> be updated instantly. Because its not in the same datacenter, therefore
> implementing a SAN is not possible, so with this in mind can my original
> question be possible and is there any Howtos document to follow..
> appreciate
> any assistance.
> "Geoff N. Hiten" wrote:
|||Sorry Geoff.N, if its not troublesome, may I communicate with u via email or
MSN, I really appreciate if its possible to understand better on this subject.
"Geoff N. Hiten" wrote:
> What you are asking about is a Geo-cluster or a geographically separated
> cluster. NSI makes some products that can give you this functionality. Some
> SAN vendors also handle SAN-level data replication for disaster
> recovery/fault tolerance setups. There are no built-in features in SQL
> Server 2000 to allow what you are asking for. SQL Server 2005 adds a new
> technology called Database Mirroring that allows you to build a multi-site
> high-availability solution.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Lewis" <Lewis@.discussions.microsoft.com> wrote in message
> news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@.microsoft.com...
>
>
|||My MSN is lewisteo@.hotmail.com
"Geoff N. Hiten" wrote:
> What you are asking about is a Geo-cluster or a geographically separated
> cluster. NSI makes some products that can give you this functionality. Some
> SAN vendors also handle SAN-level data replication for disaster
> recovery/fault tolerance setups. There are no built-in features in SQL
> Server 2000 to allow what you are asking for. SQL Server 2005 adds a new
> technology called Database Mirroring that allows you to build a multi-site
> high-availability solution.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Lewis" <Lewis@.discussions.microsoft.com> wrote in message
> news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@.microsoft.com...
>
>
|||I prefer to assist on the public newsgroups where everyone can benefit from
the discussions. Private assistance is known as "consulting" and is
generally done for pay.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lewis" <Lewis@.discussions.microsoft.com> wrote in message
news:60368F4E-899E-4833-9ED6-591FF5A3535C@.microsoft.com...[vbcol=seagreen]
> Sorry Geoff.N, if its not troublesome, may I communicate with u via email
> or
> MSN, I really appreciate if its possible to understand better on this
> subject.
> "Geoff N. Hiten" wrote:
|||Not a problem, as I was saying, my setup is such:
Data Center 1:
2 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
internet, another lease line to data center 2.
Data Center 2:
1 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
internet and another leased to data center 1.
I would like to have all servers in both data center clustered for
redundancy, is this possible ?
"Geoff N. Hiten" wrote:
> I prefer to assist on the public newsgroups where everyone can benefit from
> the discussions. Private assistance is known as "consulting" and is
> generally done for pay.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Lewis" <Lewis@.discussions.microsoft.com> wrote in message
> news:60368F4E-899E-4833-9ED6-591FF5A3535C@.microsoft.com...
>
>
|||At this time, you cannot cluster using native SQL tools across a geographic
separation. Also, I think you may have an incomplete understanding of how
clustering works and what it actually offers. The following article is a
good starting point. It mostly describes running in a Windows 2000
environment. There are a few technical differences when running on Windows
2003, but the fundamentals are the same.
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lewis" <Lewis@.discussions.microsoft.com> wrote in message
news:1D291D57-DB1E-439B-806C-91F4D83673DF@.microsoft.com...[vbcol=seagreen]
> Not a problem, as I was saying, my setup is such:
> Data Center 1:
> 2 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
> internet, another lease line to data center 2.
> Data Center 2:
> 1 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
> internet and another leased to data center 1.
> I would like to have all servers in both data center clustered for
> redundancy, is this possible ?
> "Geoff N. Hiten" wrote:
on Win Server 2003 Ent without SAN but could not find a good step by step
howtos to it.
Could some kind gentlemen point me to a good article ? please and thanks in
advance.
SCSI clusters only support two nodes. As far as Active/Active/Active
terminology, that really doesn't express what your intent is. The new
terminology is Multi-instance and you need to state how many nodes and SQL
instances you are trying to build in your cluster. I.E I want to build a
four node cluster with three SQL instances.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lewis" <Lewis@.discussions.microsoft.com> wrote in message
news:3C882765-40EE-424E-8BEF-A5F768D2207D@.microsoft.com...
>I read that its possible to implement an Active/Active/Active with SQL 2000
> on Win Server 2003 Ent without SAN but could not find a good step by step
> howtos to it.
> Could some kind gentlemen point me to a good article ? please and thanks
> in
> advance.
|||My setup is a 2 data center, 2 server in location and 1 single in another. I
would like to implement a fail safe SQL system. So this will be a 3 node
system and I am intending that at any single update to database, all 3 will
be updated instantly. Because its not in the same datacenter, therefore
implementing a SAN is not possible, so with this in mind can my original
question be possible and is there any Howtos document to follow.. appreciate
any assistance.
"Geoff N. Hiten" wrote:
> SCSI clusters only support two nodes. As far as Active/Active/Active
> terminology, that really doesn't express what your intent is. The new
> terminology is Multi-instance and you need to state how many nodes and SQL
> instances you are trying to build in your cluster. I.E I want to build a
> four node cluster with three SQL instances.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Lewis" <Lewis@.discussions.microsoft.com> wrote in message
> news:3C882765-40EE-424E-8BEF-A5F768D2207D@.microsoft.com...
>
>
|||What you are asking about is a Geo-cluster or a geographically separated
cluster. NSI makes some products that can give you this functionality. Some
SAN vendors also handle SAN-level data replication for disaster
recovery/fault tolerance setups. There are no built-in features in SQL
Server 2000 to allow what you are asking for. SQL Server 2005 adds a new
technology called Database Mirroring that allows you to build a multi-site
high-availability solution.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lewis" <Lewis@.discussions.microsoft.com> wrote in message
news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@.microsoft.com...[vbcol=seagreen]
> My setup is a 2 data center, 2 server in location and 1 single in another.
> I
> would like to implement a fail safe SQL system. So this will be a 3 node
> system and I am intending that at any single update to database, all 3
> will
> be updated instantly. Because its not in the same datacenter, therefore
> implementing a SAN is not possible, so with this in mind can my original
> question be possible and is there any Howtos document to follow..
> appreciate
> any assistance.
> "Geoff N. Hiten" wrote:
|||Sorry Geoff.N, if its not troublesome, may I communicate with u via email or
MSN, I really appreciate if its possible to understand better on this subject.
"Geoff N. Hiten" wrote:
> What you are asking about is a Geo-cluster or a geographically separated
> cluster. NSI makes some products that can give you this functionality. Some
> SAN vendors also handle SAN-level data replication for disaster
> recovery/fault tolerance setups. There are no built-in features in SQL
> Server 2000 to allow what you are asking for. SQL Server 2005 adds a new
> technology called Database Mirroring that allows you to build a multi-site
> high-availability solution.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Lewis" <Lewis@.discussions.microsoft.com> wrote in message
> news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@.microsoft.com...
>
>
|||My MSN is lewisteo@.hotmail.com
"Geoff N. Hiten" wrote:
> What you are asking about is a Geo-cluster or a geographically separated
> cluster. NSI makes some products that can give you this functionality. Some
> SAN vendors also handle SAN-level data replication for disaster
> recovery/fault tolerance setups. There are no built-in features in SQL
> Server 2000 to allow what you are asking for. SQL Server 2005 adds a new
> technology called Database Mirroring that allows you to build a multi-site
> high-availability solution.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Lewis" <Lewis@.discussions.microsoft.com> wrote in message
> news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@.microsoft.com...
>
>
|||I prefer to assist on the public newsgroups where everyone can benefit from
the discussions. Private assistance is known as "consulting" and is
generally done for pay.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lewis" <Lewis@.discussions.microsoft.com> wrote in message
news:60368F4E-899E-4833-9ED6-591FF5A3535C@.microsoft.com...[vbcol=seagreen]
> Sorry Geoff.N, if its not troublesome, may I communicate with u via email
> or
> MSN, I really appreciate if its possible to understand better on this
> subject.
> "Geoff N. Hiten" wrote:
|||Not a problem, as I was saying, my setup is such:
Data Center 1:
2 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
internet, another lease line to data center 2.
Data Center 2:
1 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
internet and another leased to data center 1.
I would like to have all servers in both data center clustered for
redundancy, is this possible ?
"Geoff N. Hiten" wrote:
> I prefer to assist on the public newsgroups where everyone can benefit from
> the discussions. Private assistance is known as "consulting" and is
> generally done for pay.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Lewis" <Lewis@.discussions.microsoft.com> wrote in message
> news:60368F4E-899E-4833-9ED6-591FF5A3535C@.microsoft.com...
>
>
|||At this time, you cannot cluster using native SQL tools across a geographic
separation. Also, I think you may have an incomplete understanding of how
clustering works and what it actually offers. The following article is a
good starting point. It mostly describes running in a Windows 2000
environment. There are a few technical differences when running on Windows
2003, but the fundamentals are the same.
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lewis" <Lewis@.discussions.microsoft.com> wrote in message
news:1D291D57-DB1E-439B-806C-91F4D83673DF@.microsoft.com...[vbcol=seagreen]
> Not a problem, as I was saying, my setup is such:
> Data Center 1:
> 2 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
> internet, another lease line to data center 2.
> Data Center 2:
> 1 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
> internet and another leased to data center 1.
> I would like to have all servers in both data center clustered for
> redundancy, is this possible ?
> "Geoff N. Hiten" wrote:
Subscribe to:
Posts (Atom)