Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL server fail over cluster disk resource change

Posted on 2011-09-28
4
Medium Priority
?
297 Views
Last Modified: 2012-05-12
I currently have an instance SQL server setup up in a failover cluster environment.
I recently added 2 new SAN storage Disk(v:- w:) to the cluster and migrated all databases from SAN drives s: and t:
I used SQL Server detach(s: and  t:) and  attach(v: and w:) to move the databases. For the master,msdb and model databases I used:

ALTER DATABASE model MODIFY FILE ( NAME = DB , FILENAME = 'V:\path\file' )

I then went in to SQL Server -> Surface area configuration – Right click instance – Advance and set the startup drives to be v: and w:

The SQL server instance starts ok and I verified I am using V: and W:

The new v: and W: drives are available disk resources in fail over cluster management

When I went into Failover cluster managemnt and brought the S: and T: drives offline it’s shutting down the SQL server instance. I removed all dependencies on these drives.

What’s the proper way to remove the S: and the T: drive resources from the cluster without bringing the SQL server instance offline?

Why would bringing the s: and t: drives offline stop the SQL server instance?

What did I do wrong here?
0
Comment
Question by:wademi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 21

Expert Comment

by:JestersGrind
ID: 36718742
In cluster management, check the dependencies of the SQL Server instance.  They are probably still referring to the S: and T: drive.

Greg

0
 

Author Comment

by:wademi
ID: 36718805
Thanks JestersGrind:. I stated in the problem description that I removed all dependencies.
0
 
LVL 21

Accepted Solution

by:
JestersGrind earned 1500 total points
ID: 36718883
Sorry, I missed that.  These are the steps to take to remove drives from a SQL Server cluster

In Cluster Administrator
Take the SQL Server resource offline
Go to the properties of SQL Server resource --> Dependencies --> remove the disk from the dependency list
Bring the SQL Server resource back online

Greg

0
 

Author Closing Comment

by:wademi
ID: 36965362
cecfeqwdfc
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question