Solved

SQL server 2008 cluster & file ownerships

Posted on 2012-03-30
3
249 Views
Last Modified: 2012-04-10
Hi,
I need to understand file ownership on SQL server cluster which is based on Microsoft cluster technology.

I have a SAN drive , a clustered disk (I drive)  mounted on both SQL server nodes but only one can see it . The other can access it via windows share but can't see it as a drive.

Now I thought is wrong mainly because if it's a clustered resource then both node should able to see it at any given time.

How does drive sharing works under Microsoft cluster technology?

Please paste me some MVP blog links than MS doc pages.

Thanks
0
Comment
Question by:crazywolf2010
  • 2
3 Comments
 
LVL 22

Accepted Solution

by:
65td earned 500 total points
ID: 37789198
•Microsoft uses what is called a shared-nothing model when it comes to managing disks. Shared-nothing means that each physical disk or hardware fault-tolerant disk set on the shared SCSI bus can be owned (accessed) by only one node of the cluster at a time.


see under Disk Configuration section:
http://support.microsoft.com/kb/259267
0
 

Author Comment

by:crazywolf2010
ID: 37789504
Hi,
Could you please paste me a link or a document which details on how shared nothing model works?

Thanks
0
 
LVL 22

Expert Comment

by:65td
ID: 37829869
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Convert SP in a format for debugging 7 30
Error in query 3 52
Removing SQL Replication from Microsoft SQL Server 2008 R2 2 11
SQL Server Question 5 25
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

911 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

19 Experts available now in Live!

Get 1:1 Help Now