Failover cluster with Mirror server 2008

• Database admin(DBA)

  SSCertifiable

  Points: 5373

  More actions

  February 9, 2017 at 12:31 pm

  #318598

  Hello All,
  we have configured DB mirroring(with out witness) on cluster environment(Active\passive),Now we need to reboot the node 2 which is active node.
  Just i have to go to Failover cluster manager ,right lick failover from node 2 to node 1,the Db's will go to automatically to node 1 after failover? or shoid i do anything at Db level?
  Please clarify

  Thanks in advance!!

  Best Regards,

  SQL server DBA

• Perry Whittle

  SSC Guru

  Points: 234065

  More actions

  February 10, 2017 at 5:36 am

  #1927728

  check this

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉