Possibility to add database on a shared drive which is not dependency of SQL Server resource
-
Hi 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
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.
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,
Bartek
-
There is a reason for the dependency of sqlserver instances vs drives !
Why are you tempted to avoid this dependency ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
b.ozga (6/8/2009)
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.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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Hi ALZDBA
Believe 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,
Bartek
-
You'll either have to fix the dependencies or move the DB files to a drive that's already a dependency.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Thank 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,
Bartek
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply