Failover clustering without SAN & SCSI ?

kumar

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

Subscribe Post Reply

4223

Greg D. Moore \(Strider\)

"kumar" <sg****@yahoo.com.sg> wrote in message
news:d1**************************@posting.google.c om...

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.public.sqlserver.clustering
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

Similar topics

MS SQL Clustering and Failover

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...

Microsoft SQL Server

Losing dbobtions on clustered server failover?

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 -...

Microsoft SQL Server

ASP.NET w/ SQL Server Sessions & Cluster Failover

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...

ASP.NET

Failover of DB2 Tools Catalog on MSCS

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...

DB2 Database

failover cluster using 64 bit windows 2k3 on single HBAs and DS400 with dual controller

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...

Microsoft SQL Server

Failover Cluster not using all allocated RAM

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...

Microsoft SQL Server

DB2 Failover

by: afreema | last post by:

I am interested in failover for DB2 Version 9 on an AIX environment. Can you give me any recommendations?

DB2 Database

Fast-Start Failover An Overview In Dataguard Environment

by: Vinod Sadanandan | last post by:

Fast-Start Failover An Overview In Dataguard Environment ============================================================================= This article describes the automatic fast start failover...

Oracle Database

How to increase web server uptime with DNS failover

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...

HTML / CSS

Speedup your spring application

by: linyimin | last post by:

Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...

General

Steps manually installing IntelliJ IDEA.

by: erikbower65 | last post by:

Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...

General

Development of Funny H5 Game - Toy Claw

by: kcodez | last post by:

As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...

HTML / CSS

Access Europe meeting on Wed 6 Sept - Database Analyzer and other tools

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

Cancel Print Action if Sub form has No Records

by: DJRhino1175 | last post by:

When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...

Microsoft Access / VBA

Python code for finding the longest common subsequence

by: Rina0 | last post by:

I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...

Python

To verify entry of a dropdown

by: DJRhino | last post by:

Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...

Microsoft Access / VBA

How does React native implement an English player?

by: lllomh | last post by:

How does React native implement an English player?

Mobile Development

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA