Create Database - CONTAINMENT

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  October 22, 2013 at 11:30 am

  #1660621

  It's the Database!!! (10/22/2013)

  ---

  Why would you put a DB on the C:\ of a clustered SQL server?

  You can't even do that, a database file for a clustered SQL Server has to go on a cluster resource. Hence I suspect there are two different servers involved here, first one clustered, second one not.

  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

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  October 22, 2013 at 11:34 am

  #1660626

  GilaMonster (10/22/2013)

  ---

  It's the Database!!! (10/22/2013)

  ---

  Why would you put a DB on the C:\ of a clustered SQL server?

  You can't even do that, a database file for a clustered SQL Server has to go on a cluster resource. Hence I suspect there are two different servers involved here, first one clustered, second one not.

  Yes I know, that is why I asked about the cluster valaidation and disks. the DB should never go on the C:\ only the OS clustered or stand alone.

  So my question was a repeat of what you have asked, why would you put the DB on the C:\? I should have said this "why would you put the DB on the C:\, it is not clustered?"

  I also think that there are 2 different things going on here too.

  MCSE SQL Server 2012\2014\2016