Home Forums SQL Server 7,2000 In The Enterprise Possibility to add database on a shared drive which is not dependency of SQL Server resource RE: Possibility to add database on a shared drive which is not dependency of SQL Server resource

  • June 8, 2009 at 3:03 am

    #1005971

    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 recoverability

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