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 drive issue Expand / Collapse
Author
Message
Posted Monday, July 28, 2014 2:59 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:05 PM
Points: 59, Visits: 109
Running out of space on active/pasive cluster (physical servers attached to SAN). netops added new drive, I see the new drive as a clustered resource, see it in disk manager, can't see it explorer. Management studio can't see drive, but I could backup to the drive by typing letter. Looked at dependencies in sql resoruce for drive, none set for any of the drives including new one. This seems kind of a mixed issue, but this is on a production server.
Post #1597070
Posted Tuesday, July 29, 2014 1:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 3:26 AM
Points: 67, Visits: 216
The reason you're not able to 'see' the drive through SSMS is that it needs to be added as a dependency to the SQL Server clustered resource. Are you able to try this and see if resolves your issue? Not sure why you're not seeing this in explorer.
Post #1597169
Posted Tuesday, July 29, 2014 6:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:38 PM
Points: 6,350, Visits: 13,675
if you're looking in explorer on the node where the disk is not online you won't see it.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1597248
Posted Tuesday, July 29, 2014 8:30 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:05 PM
Points: 59, Visits: 109
little scary but went into cluster admin and noticed no dependencies on any of the drives
Post #1597323
Posted Tuesday, July 29, 2014 9:21 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 3:26 AM
Points: 67, Visits: 216
Just to confirm you're looking at the dependencies for the SQL Server cluster resource? If that's the case and there are no disks present as dependencies then you definitely need to add these in, this will be all shared drives that SQL Server will need to used.

Also the SQL Server Network name resource will need to be a added as a dependency too.

Post #1597350
Posted Tuesday, July 29, 2014 9:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:05 PM
Points: 59, Visits: 109
yes new job just did not set this one up, however it is a prod server so treading lightly, been a year since I built my last one kind of suprised it works
Post #1597354
Posted Tuesday, July 29, 2014 9:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 3:26 AM
Points: 67, Visits: 216
Yeah I'm surprised myself. What version of the Windows Server is it running on?
Post #1597371
Posted Tuesday, July 29, 2014 9:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:05 PM
Points: 59, Visits: 109
windows 2008, gets better just sent link to steps to add drive to resource, looks like resource needs to come off line, 1 minute later cluster went down, not sure they understood taking resource offline would take down the cluster.....
Post #1597373
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse