Go Premium for a chance to win a PS4. Enter to Win

x
?
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
Medium Priority
?
246 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
4 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 2000 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

876 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