AG issue

  • Hello All,
    Thank you in advance for your time 🙂
    I had an issue and somehow we were able to stabilize things with reboot but I did not like the way we did it..reboot for me is not a best option due to the fact that it brings down time, We have 2 nodes and have AG groups setup ( 4 groups)
    ISSUE : Team did updates to Cluster. after sometime and updating drivers completed - We had primary node All db's in synchronized state however on secondary we had FEW in 'synchronized" and few in "RECOVERY PENDING" state, these pending db's were part of specific 2 AG groups ( out of total 4). What should have been the proper way of bringing recovery pending db's to synchronized state. 
    SUGGESTIONS: Please advise and help. I am learning SQL day by day 🙂 it is day 1 always.

  • Do you have any logs? I would check secondary sql logs and primary. It might have just needed time.

  • Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

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