Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL server 2008 cluster & file ownerships

Posted on 2012-03-30
3
Medium Priority
?
257 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 22

Accepted Solution

by:
65td earned 2000 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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

636 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