Solved

SQL server fail over cluster disk resource change

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

Accepted Solution

by:
mozcullu earned 500 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

758 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now