Ford Fairlane (3/26/2014)
DR is different for different application. Some are only using the WFC for HA and not worried about DR others are using the AlwaysOn groups for DR. Now I have 3 or 4 different systems in one AlwaysOn group yet only one of the systems wants to test its DR capabilities.Can this be done with out affecting the other databases in the group. I don't think so, if if this is the case what would be the best way to test DR for an individual system in a AlwaysOn group ?
No, that's not possible. It's only possible to failover the whole group not individual Dbs within the group. When you design Always ON groups, you should always group similar DBs not dissimilar ones.
To do that either you need to create AGs for separate DBs or configure DB Mirroring\Logshipping for individual DBs for the DR strategy.
--
SQLBuddy