November 8, 2006 at 9:07 am
Does anyone know why I would only be able to see 1 drive out of the 4 on the SAN from within Management Studio?
I am on Windows 2003 and SQL 2005 sp1 installed on a cluster. My sysadmin set up 4 drives (S: Data, R:Backup, L:Logs, T:Temp) and claims I am using a domain account with all the privileges I need to be able to see these drives. However, when I log in as sa and try to create a backup I can only choose the S drive. Oddly, I can type in the R drive and it will write to it but I am unable to see it.
When I try to restore from the R drive I get the error: Could not resolve specified location. Either the location does not exist, or current login does not have access to it.
Any thoughts on this would be greatly appreciated.
Thanks in advance! Kristi
November 8, 2006 at 11:47 am
how are the drives assigned between virtual servers and is it A/A or P/A?
my guess is that another node owns it at the moment and you can't access it.
November 8, 2006 at 7:29 pm
Hi Kristi,
Ask your sysadmin to add R, L and T drives as dependencies to the SQL Server service resource in the SQL cluster group. That should resolve the issue.
Good Luck.
Venu
November 10, 2006 at 9:54 am
That worked great Thanks!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply