Home Forums SQL Server 2019 SQL Server 2019 - Administration AlwaysOn : Unable to resume data movement RE: AlwaysOn : Unable to resume data movement

  • July 26, 2017 at 10:44 am

    #1952842

    Johnson Welch - Tuesday, June 20, 2017 11:20 PM

    Restart the SQL Server machine & reset the SQL Server service status to Started. sometimes solve these issue.

    Ricky Valencia - Thursday, July 20, 2017 12:32 AM

    Hi 
    This happened to us few months back. We rebooted the secondary replica server and it resolved the issue.

    Best Regards,

    This would lead me to conclude the mirroring endpoint wasnt started, it's easy to check using the following query

    select name, type_desc, state_desc, is_encryption_enabled,

    connection_auth_desc, encryption_algorithm_desc

    from sys.database_mirroring_endpoints

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

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