locked
Database Mirroring RRS feed

  • Question

  • In Database Mirroring, i configured the Principal and Mirror but when i start the mirroring process i can read the Status Message  as (Synchronizing: data is being transferred from the principal database to the mirror database). Other than that it doesn't show any message. My Principal Database says(Principal, Synchronizing) and Mirror database says(In Recovery)

    Other than that i don't read any other message like Mirroring successful or failed

    Please help me...thanks in advance

    Regards,
    Sandeep
    Monday, July 6, 2009 4:09 PM

All replies

  • If it claims its principal then its mirroring(it will never claim principal unless its currently mirroring).  You can see mirroring status in SSMS by going into database property's, mirror section. 
    Monday, July 6, 2009 4:15 PM
  • I checked the status and now it says "This database has not been configured for mirroring"....So i guess the mirroring process didn't start at all...not sure about the reason
    Monday, July 6, 2009 6:52 PM
  • well start over.  It may be that you modified the mirror then settings then closed thinking it was set up.  That happens sometimes.
    Tuesday, July 7, 2009 2:42 PM