SQL server fail over cluster disk resource change
Posted on 2011-09-28
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?