I cannot see the main backup drive in SQL cluster when attempting to do a restore. The backups for the cluster is stored on this drive. I only see three of the four SAN mapped drives (which are desiegnated as reserve drive in disk manager). Is there somewhere in SSMS I add the drive I cannot see or is this something to do with SAN?
Thanks in advance.
If the backup drive or folder is inside the SAN, you will only see it from the active node. Unless, like Elliot said, that resource was moved to the other node.
On a Windows Cluster, only one node can see a given SAN's resource. So again, if your backup folder resides on the SAN and you are connected to the passive node, you won't be able to see it from there. This is by design on a SQL failover instance, and in order to allow only one server (active instance) to read and write to the database at a time, avoiding data corruption.
Hope that helps.