Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Possibility to add database on a shared drive which is not dependency of SQL Server resource Expand / Collapse
Author
Message
Posted Monday, June 08, 2009 12:56 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 04, 2014 9:53 AM
Points: 586, Visits: 1,012
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
Post #730494
Posted Monday, June 08, 2009 1:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:10 AM
Points: 6,997, Visits: 8,410
There is a reason for the dependency of sqlserver instances vs drives !

Why are you tempted to avoid this dependency ?


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- 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
Post #730499
Posted Monday, June 08, 2009 3:03 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:36 AM
Points: 41,521, Visits: 34,438
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #730554
Posted Monday, June 08, 2009 5:24 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 04, 2014 9:53 AM
Points: 586, Visits: 1,012
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
Post #730600
Posted Monday, June 08, 2009 5:48 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:36 AM
Points: 41,521, Visits: 34,438
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #730614
Posted Monday, June 08, 2009 6:07 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 04, 2014 9:53 AM
Points: 586, Visits: 1,012
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
Cheers,
Bartek
Post #730625
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse