Solved

SQL server 2008 cluster & file ownerships

Posted on 2012-03-30
3
251 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
How can i get data when i use where clause with group by? 3 37
Query to return total 6 19
Webservices in T-SQL 3 31
SQL Server 2012 r2 - Varible Table 3 25
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

821 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