Post reply

Create Database - CONTAINMENT

  • 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

  • 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

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply