none
DAC in a single datacenter design?

    Question

  • Hi guys,

    I'm wondering if I can or should use DAC mode.  I have a single data center, single AD with a 4 node cluster and a FSW.  3 of my servers hold all of my active databases.  1 server, MB4, holds all the passive copies.  MB4 has all local disk (not attached to the SAN).  The reason for this setup it to one day move MB4 to a different building for DR purposes.

    This weekend we had to take the SAN offline for some maintenance.  I shut down the three primary servers but then the cluster service on MB4 failed because it could not obtain quorum.  I see there is no easy way to fix this for a temporary outage.

    I just read that DAC now supports single AD sites.  I was thinking maybe I can activate DAC mode.  Then in the future if the SAN was not available for some reason, or I move MB4 to a different building, that I could mount all the databases on MB4, manually of course.

    Can DAC mode work this way and if  I had it enabled would I have been able to mount my databases during our outage this morning?  Is setting up DAC mode as simple as enabling it with powershell and setting up an alternate witness server?

    Thanks for your help!

    Keivn


    -Kevin

    Saturday, May 05, 2012 2:25 PM

Answers

All replies