?
Solved

SQL server fail over cluster disk resource change

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

809 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