473,890 Members | 1,360 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Failover clustering without SAN & SCSI ?

Dear Friends,

I wanted to configure Failover cluster for SQL Server 2000 on Windows
2000 advanced servers.

I have only 2 no.s of windows 2000 advanced server m/cs. I dont have
any shared disks and SCSI drives. Can I still configure the Failover
clustering?

I would like to know more about the need for the shared disks in the
Failover clustering.

Please shed some light.

Regards
Kumar
Jul 20 '05 #1
1 4286

"kumar" <sg****@yahoo.c om.sg> wrote in message
news:d1******** *************** ***@posting.goo gle.com...
Dear Friends,

I wanted to configure Failover cluster for SQL Server 2000 on Windows
2000 advanced servers.

I have only 2 no.s of windows 2000 advanced server m/cs. I dont have
any shared disks and SCSI drives. Can I still configure the Failover
clustering?
I would recommend you ask in the microsoft.publi c.sqlserver.clu stering
newsgroup.

I suspect the answer though is no.

I would like to know more about the need for the shared disks in the
Failover clustering.
You absolutely need some way of both servers having access to the datafiles.


Please shed some light.

Regards
Kumar

Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
5883
by: Nico de Groot | last post by:
I have a 2 node Microsoft 2000 cluster with a shared storage device. I want to create automatic failover for MS SQL 2000 server. I can do that wit the following options: 1. Active/Pasive (one instance installed) 2. Active/Active (More then one instance/virtual sql servers installed) I have a question about option 2.
1
1228
by: Thomas Richards | last post by:
We have a clustered sql server 2000 installation on windows 2000. We recently lost the select into/bulkcopy option from a database. The most likely candidate appears to be a failover just before - after this happened the setting disappeared. Any ideas? Thanks Tom
1
3042
by: news.microsoft.com | last post by:
Is there an elegant way to clear out the ADO connection pool used by the SQL Server State Service following a cluster failover? We are using a SQL Cluster to store both the ASP Session State database and our application database. When the SQL Server cluster is failed-over, any "pointers" to the live connections stored in the connection pool are made invalid. When the application tries to reference these "damaged" connections, it throws...
8
4147
by: arandhawa1 | last post by:
Does anyone know how to correctly setup the Administration DB for fail over clustering on a MSCS server running DB2. Problem I have when I follow IBM's docs is that I install the Tools catalog on the first node but when I failover the cluster to the second node - DB2's Task Center no longer works since the Tools Catalog still points to the first node. Is there anyway to re-catalog the tools db so
5
3113
by: uspensky | last post by:
We are trying to setup a system to system failover cluster using two nodes (x346) which each have a single hba running to seperate controllers on the DS400. For full redundnancy, IBM recommends dual path from each node but we dont need that. The current setup has two completly seperate paths. hba on node 1 to controller A on DS400 and hba on node 2 to controller B. If i take a controller offline, failover works fine to jumo to other...
1
1400
by: astrohorse26 | last post by:
We are running on SQL 2000 on Windows 2003. We have active-passive clustering set up. We have 16 GB of RAM on each box. This past weekend, we failed over. I noticed that the Total Server Memory went from about 15.5 GB to 8 GB. I have been trying to figure out why this has occurred. Any help would be greatly appreciated.
3
4588
by: afreema | last post by:
I am interested in failover for DB2 Version 9 on an AIX environment. Can you give me any recommendations?
0
8019
by: Vinod Sadanandan | last post by:
Fast-Start Failover An Overview In Dataguard Environment ============================================================================= This article describes the automatic fast start failover configuration and the conditions for trigerring a fast start failover in dataguard environment . In Faststart failover dataguard configuration if the primary database becomes unavailable, the...
8
2731
by: Guy Macon | last post by:
How to increase web server uptime with DNS failover: For illustration, let's start with some really bad hosting... Find four free web hosts that are each 90% reliable -- in other words they each are down on average one day out of ten. Use a failover DNS system with monitoring to switch servers if one fails. On average: One server will be down one day out of ten
0
9978
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9819
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10918
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9625
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8015
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7169
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5845
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4674
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4270
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.