sql 2012 always on - failover specific databases?

• cheshirefox

  Hall of Fame

  Points: 3464

  More actions

  August 24, 2012 at 11:20 am

  #265922

  Hi -

  I have multiple databases configured in one availability group.

  Is it possible to failover one of databases w/in the availability group?

  I know the entire group will failover with the following:

  ALTER AVAILABILITY GROUP AVGGroupName FORCE_FAILOVER_ALLOW_DATA_LOSS;

  Don't think it's possible at the DB level though.

  Thanks.

• Kishore-132325

  Hall of Fame

  Points: 3784

  More actions

  August 28, 2012 at 6:11 am

  #1530743

  Not at DB level.

  All DBs get failed over within that AG.

  However, if you have multiple AGs on the same instance, you can fail them over individually.

  HTH

  Kishore