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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

864 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now