InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 17:43:49 GMT20http://www.sqlservercentral.com/Forums/Topic730494-54-1.aspxThank you for your responses. I was looking for a hack but it seems I will have to wait till evening to fix dependencies. No drive is in the resource dependency :Whistling:Cheers,BartekMon, 08 Jun 2009 06:07:50 GMTb.ozgahttp://www.sqlservercentral.com/Forums/Topic730494-54-1.aspxYou'll either have to fix the dependencies or move the DB files to a drive that's already a dependency.Mon, 08 Jun 2009 05:48:20 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic730494-54-1.aspxHi ALZDBABelieve me, I got burnt my fingers burnt few times with that message :) so I know how SQL Server cluster should work. As I wrote, I discovered lack of drives in dependencies by accident. I'm sure you came across situation that everything had been working fine until you had to change something and then you saw a mess which should be clean up.I asked you because I need this database running until evening, then I will have time to fix the SQL Server resource.Regards,BartekMon, 08 Jun 2009 05:24:33 GMTb.ozgahttp://www.sqlservercentral.com/Forums/Topic730494-54-1.aspx[quote][b]b.ozga (6/8/2009)[/b][hr]Do you know a way to attach\create database on a disk which is not SQL Server dependency but it is in a cluster group? Any help appreciated.[/quote]Can't be done. When running in a cluster all drives that SQL uses have to be dependencies of the SQL service. This is to ensure that the drives are owned by the correct node after a failover and that the drive resources come online before the SQL resource does.Mon, 08 Jun 2009 03:03:12 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic730494-54-1.aspxThere is a reason for the dependency of sqlserver instances vs drives !Why are you tempted to avoid this dependency ?Mon, 08 Jun 2009 01:07:32 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic730494-54-1.aspxHi guys,Yesterday, I detached one of my relevant databases to perform some disk related task. When I tried to attach it again I got well known message[quote]Cannot use file 'd:\xxxx_data.mdf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used.[/quote]Server has been running for couple of months without stop and nobody has been aware that d: drive is not in SQL Server resource dependency.Do you know a way to attach\create database on a disk which is not SQL Server dependency but it is in a cluster group? Any help appreciated. Cheers,BartekMon, 08 Jun 2009 00:56:13 GMTb.ozga