?
Solved

SQL server fail over cluster disk resource change

Posted on 2011-09-28
2
Medium Priority
?
308 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 Comments
 
LVL 7

Accepted Solution

by:
mozcullu earned 2000 total points
ID: 36717792
except databases there are some other things like errorlog pointing to drives. Check registry for SQL Server on both nodes that they are not pointing to old drives
0
 

Author Comment

by:wademi
ID: 36718434
That was so helpful.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

770 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