Solved

How do I create a SQL Fail Over cluster on 2 servers that so not have a physical shared disk

Posted on 2008-10-15
6
241 Views
Last Modified: 2010-03-19
I would like to install a 2 node SQL 2005 fail over cluster. We would like to have 1 server in our corporate office and the other in a remote office for business continuity purposes. Every time I try to install the SQL 2005 fail over cluster I get the window that says I have no physical disks to install it on. My question is how do I configure the cluster administrator and SQL 2005 to use a shared disk for the cluster fail over. I should not need to have both servers pluged into a shared disk storage to do this
0
Comment
Question by:lastcall1234
  • 2
6 Comments
 
LVL 22

Expert Comment

by:65td
ID: 22733562
Do these servers have shared disk (SAN, NAS or iSCSI)?
0
 

Author Comment

by:lastcall1234
ID: 22735022
Sorry I should have added that. We do have an external array that one SQL server is plugged in to through fiber cable. The issue is I don't want to have both servers plugged in to it since we would like to move one server to another office for disaster recovery purposes. Is it possible to do a SQL fail over cluster in this case
0
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 500 total points
ID: 22738245
In order to configure a SQL cluster BOTH servers have to be in the same subnet, members of the same domain and BOTH be connected to the same external storage array with a shared drive

In your case the best you could do is a SQL mirror or use transaction log shipping.  You will not be able to setup a SQL cluster.
0
 
LVL 22

Expert Comment

by:65td
ID: 22740522
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
OPENDATASOURCE 8 42
SQL Date from a string 4 70
insert query with value having 's 2 58
Downgrading MS SQL 2008 R2 Enterprise to MS SQL 2005 Standard? 12 66
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question