Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cluster backup drives Expand / Collapse
Author
Message
Posted Thursday, July 25, 2013 10:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 10:22 AM
Points: 7, Visits: 59
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
Post #1477614
Posted Thursday, July 25, 2013 11:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
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
Post #1477633
Posted Thursday, July 25, 2013 12:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 10:22 AM
Points: 7, Visits: 59
Can you provide reasons why I would not see the drive the backups are backed up to?

Thanks in advance



James Pettigrew
Systems Manager
Post #1477668
Posted Thursday, July 25, 2013 12:57 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
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
Post #1477687
Posted Thursday, July 25, 2013 1:13 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:24 AM
Points: 373, Visits: 1,235
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.
Post #1477696
Posted Friday, July 26, 2013 6:24 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
Post #1477961
Posted Friday, July 26, 2013 7:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 10:22 AM
Points: 7, Visits: 59
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
Post #1477992
Posted Friday, July 26, 2013 8:40 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 5:21 AM
Points: 811, Visits: 2,419
in the failover cluster manager, check that the cluster disk for your backup drive is a dependency of the sql server resource
Post #1478047
Posted Sunday, July 28, 2013 11:48 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 10:28 AM
Points: 398, Visits: 2,434
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.
Post #1478383
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse