SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cluster backup drives


Cluster backup drives

Author
Message
jpettigrew
jpettigrew
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 76
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.


James Pettigrew
Systems Manager
Elliott Whitlow
Elliott Whitlow
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10008 Visits: 5314
jpettigrew (7/25/2013)
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?

If they are designated Reserved then you are on a node where the SQL is NOT running. They would be online if you were on the same node.

Is the backup drive a clustered drive or is it "local" to a node, I think you need to give some additional detail.

CEWII
jpettigrew
jpettigrew
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 76
Can you provide reasons why I would not see the drive the backups are backed up to?

Thanks in advance


James Pettigrew
Systems Manager
Elliott Whitlow
Elliott Whitlow
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10008 Visits: 5314
Please answer the question I posed.

SQL will show local drives on the node it is on I believe. I believe it will not show drives that are in another resource group even if that resource group in currently owned by that node. It will show disks that are in the resource group with SQL.

CEWII
sql-lover
sql-lover
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1573 Visits: 1930
jpettigrew (7/25/2013)
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.
durai nagarajan
durai nagarajan
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1603 Visits: 2775
jpettigrew (7/25/2013)
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.


How are you connecting by Cluster ip or name (or) node (ip or name)?

Regards
Durai Nagarajan
jpettigrew
jpettigrew
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 76
These are all good questions that I am not able to answer right now but something for me to find out. My company currently colocate the cluster in a data center where the setup was done by the company providing the equipment and space. These are questions I will ask.

Thanks in advance.


James Pettigrew
Systems Manager
adb2303
adb2303
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1272 Visits: 3137
in the failover cluster manager, check that the cluster disk for your backup drive is a dependency of the sql server resource
SQLisAwE5OmE
SQLisAwE5OmE
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1054 Visits: 3068
jpettigrew (7/25/2013)
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 you are looking at is part of the shared disk, then it will not show up on Passive Node....it will only show on the active node....

SueTons.

Regards,
SQLisAwe5oMe.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search