Thursday, March 22, 2012

active/passive cluster with san drive

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

No comments:

Post a Comment