none
Mirroring SQL Server 2016 RRS feed

  • Question

  • Hello,

    Using this setup:
    2 Machines with
    64 GB of RAM
    8 Cores
    Windows Server 2016 Standard
    SQL Server 2016 Standard SP1 CU3
    3 databases configured with Mirroring + Witness

    When we lose one node the failover works perfectly. (cutting the networking connection)

    When the lost node rejoins the network, only one mirroring is able to recover, the others make timeout during the redo phase.

    On SQL Server 2008 R2 we didn't have this behavior.

    Is this a new feature to protect the active node of service the production workload?

    Thank you, 


    Joao Martins DBA


    Thursday, July 13, 2017 9:23 AM

All replies

  • Hi João Martins,

    >> Is this a new feature to protect the active node of service the production workload?

    I don’t think so, could you please post the related events from SQL Server error log(on both principal and mirror server) so we can have a better understanding about the issue?  

    If you have any other questions, please let me know.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, July 14, 2017 5:18 AM
    Moderator
  • But why mirroring ?

    Always On Basic Availability Groups provide a high availability solution for SQL Server 2016 Standard Edition

    https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, July 16, 2017 5:31 AM