there is no way to redirect! you can setup log shipping between this cluster and another stand alone machine and point
your clients to the standalone server if the san fails and takes the cluster down.
http://support.microsoft.com/default.aspx? scid=
http://support.microsoft.com/support/sql/content/2000papers/LogShippingFinal.asp Hina Masud
Microsoft
Disclaimer:
This posting is provided AS IS with no warranties, and confers no rights.
Get Secure! ->
http://www.microsoft.com/security --------------------
-Content-Class: urn:content-classes:message
-From: "Milla" <njangson@aol.com>
-Sender: "Milla" <njangson@aol.com>
-Subject: Using a local drive
-Date: Mon, 30 Jun 2003 12:39:02 -0700
-Lines: 13
-Message-ID: <02fe01c33f3f$4290c7e0$a301280a@phx.gbl>
-MIME-Version: 1.0
-Content-Type: text/plain;
- charset="iso-8859-1"
-Content-Transfer-Encoding: 7bit
-X-Newsreader: Microsoft CDO for Windows 2000
-X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
-Thread-Index: AcM/P0KQnB4Nx2PVSVuWWLxLFpHMxQ==
-Newsgroups: microsoft.public.sqlserver.clustering
-Path: cpmsftngxa09.phx.gbl
-Xref: cpmsftngxa09.phx.gbl microsoft.public.sqlserver.clustering:1438
-NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
-X-Tomcat-NG: microsoft.public.sqlserver.clustering
-
-I have a sql server cluster running on a Dell SAN (RAID
-10) on which my sql server database resides (d:\Program
-files\Microsoft SQL Server\MSSQL\DATA. I know if this
-shared SAN come down the cluster will be meaningless,
-because both servers share the drives. I am looking for a
-way to still run sql server in case my san was down. On
-my c-drive a created a path:
-c: \Program files\Microsoft SQL Server\MSSQL\DATA. I
-make a weekly copy of the database file to this path. Is
-there a way I can redirect SQL Server 2000 to look at the
-local drive if the san stop running?
- Thanks
- Milla
-
