locked
principal db in "principal, synchronizing" state, the mirror in "restoring" state RRS feed

  • Question

  • We have mirroring setup for 5 dbs, 4 of which are synchronized and 1 which is in "synchronizing" state on the principal and "restoring" state on the mirror. Mirroring for all dbs has been working fine for the past several months and we have a witness that has allowed automatic failover in the past without problems.

     

    This database has several bulk inserts performed throughout the day and am sure there is some latency due to the size of these transactions.

     

    Not sure as to why this is happening all of a sudden, but the db in question has been in this state for the past 12 hrs.  I checked the mirroring status on the principal and it states that it is "synchronizing: data is being transferred from principal to mirror", but the mirror server states that db is in "restoring" state.  Can anyone suggest as to how I can get the database on the mirroring server to get back to "mirror, synchronizing/restoring..." state? Or suggest on how I can troubleshoot this?

     

    Thanks in advance.

     

    Wednesday, September 26, 2007 5:42 PM

All replies

  • Have you tried pulling up the Database Mirroring Monitor, to see what it shows?  Do you have Unsent Log or Unrestored Log?  Does the I/O subsystem on the mirror have comparable I/O capacity to the Principal?

     

    Thursday, September 27, 2007 3:36 AM
  • I have the same problem(principal db in principal, synchronizing state and mirror in "In Recovery state".....Did you find any solution???
    Please help me....Thanks in advance

    Regards,
    Sandeep


    • Proposed as answer by JHParra Wednesday, August 12, 2009 11:08 PM
    Monday, July 6, 2009 6:35 PM
  • I had this problem and my solutions grant permission to my user session to directory C:\Archivos de programa\Microsoft SQL Server\MSSQL.2\MSSQL\Binn  please try and give opinion
    Wednesday, August 12, 2009 11:15 PM