locked
database Mirror Synchronizing RRS feed

  • Question

  • sqlserver database Mirror away Synchronizing
    Monday, July 20, 2020 3:51 AM

All replies

  • Mirror Monitor is your first friend- it provides info on: how long it can take to sync, latest moved transaction, etc. A lot of helpful info

    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

    Monday, July 20, 2020 4:16 AM
  • Hi khann kosal,

    Synchronizing state mean that the principal server is sending log records to the mirror server, the mirror is trying to catch up. Please check the Database Mirroring Monitor as Uri mentioned. Expand Databases, and select the database to be monitored. Right-click the database, select Tasks, and then click Launch Database Mirroring Monitor. 

    If you have any progress, please share us the result.

    Best regards,
    Cathy 

    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

    Tuesday, July 21, 2020 2:37 AM
  • Hi khann,

    Is there any progress? Waiting for your update.


    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

    Wednesday, July 22, 2020 6:43 AM