February 22, 2005 at 8:13 am
Can anyone explain why master..xp_fixeddrives returns false drive information on a Active/Active cluster servers, which utilize a storage array? My cluster server has 2 physical servers called Node1 and Node2. It also has 2 logical servers called SQL1 and SQL2, this is where SQL Server was installed. SQL1 utilizes drives G:\, L:\, and S:\. SQL2 utilizes drives F:\, H:\, and X:\. When executing master..xp_fixeddrives on SQL1, I receive a display of G:\, L:\, and S:\. When executing master..xp_fixeddrives on SQL2, I receive a display of F:\, G:\, H:\, and X:\. Therefore, the big question is why does the G:\ drive display for SQL1 and SQL2 when it is only utilized by SQL1?
February 22, 2005 at 8:48 am
Is it added as a resource somewhere or is it the quorum?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
February 22, 2005 at 8:56 am
I do not find the G:\ drive added as a resource to SQL2. I checked the Windows registry, SQL Server properties, and the Cluster Administrator.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply