none
2019 Always On Availability - All Secondary instances show Synchronizing - Data Loss RRS feed

  • Question

  • I finally got my 2019 Always On Availability Group running, and all connections working.
    However, all Secondary instances show Synchronizing -with Data Loss.

    I have searched google and cannot find any useful information on this issue.
    Any information on this issue would be great.

    If I try to test the failover feature, it states that one or more databases are not synchronized.
    I would LOVE to test this out and make sure everything is going to run right, as I need to put the sites back on this server and put it live.
    All sites have been running on a non-server backup for about a month now. 

    Any assistance would be great.

    Thank you.
    Wayne
    • Edited by carrzkiss Monday, May 18, 2020 6:43 PM Added more information.
    Monday, May 18, 2020 6:22 PM

Answers

  • I watched a video that finally showed me something that none of the others did.
    During the Availability Wizard, after adding in all the servers
    Choose [Automatic Failover]
    For each server, you want to failover.
    This will make the servers Synchronize with the Primary.
    • Marked as answer by carrzkiss Monday, May 18, 2020 8:20 PM
    Monday, May 18, 2020 8:20 PM