August 17, 2012 at 12:17 pm
I had an old clustered instance on my server that I needed to get rid of. I went through each node and removed the instance from the cluster. After that, I was trying to re-purpose the disk resources for a new instance, and the SQL Cluster Instance setup threw an error stating that
"The disk resource 'OldInstance_HostDrive' is already in use by resource 'MSDTC-SQL Server (OldInstance)'. To use a disk in a new SQL Server failover cluster instance, the disk must not have any dependencies that reference it."
So, I went to component services to verify that this particular MSDTC was still in existence and, sure enough, it is. So, now I need to find the best way to remove that MSDTC instance from the cluster, thus freeing up my storage resources.
Any help you can provide would be greatly appreciated!
August 17, 2012 at 12:25 pm
It should be as easy as going into the Failover Cluster Manager and deleting the MSDTC resource from the Cluster Group. What is your Windows version out of interest?
August 17, 2012 at 12:27 pm
Unfortunately, the cluster group does not exist any longer, nor is there any other place in Failover Cluster Manager that lists "Orphaned Resource" or anything like that.
Windows Version: Windows Server 2008 R2 Enterprise Edition
August 17, 2012 at 1:27 pm
Apparently others have had this same problem, with no solution: http://www.sqlservercentral.com/Forums/Topic1304211-391-1.aspx
August 17, 2012 at 5:42 pm
try it from the command line:
open a command prompt and run:
Cluster res
to list all resources that are still there, then run:
Cluster res "resource name"/Delete
to delete any orphaned resources.
Can't test it right now. Sorry about that.
Edward
August 20, 2012 at 12:28 pm
Edward, thank you for your response. This worked perfectly.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply