Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL server fail over cluster disk resource change

Posted on 2011-09-28
4
Medium Priority
?
301 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
  • 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Screencast - Getting to Know the Pipeline

885 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