locked
Mirror database in recovery status RRS feed

  • Question

  • I have mirroring configured in my environment
    When i click on server-1 which is principal
    I can see my database status as  (Principal,synchronizing)

    when I go to server-2 which is mirror
    I can see my database status as --(In recovery)

    This happend later to restart  the mirror sever to apply some updates

    In the mirroring monitor the principal mirroring state is synchronizing but in mirror  is ''error retrieving data''

    In this server i have another database in mirroring  but their status is ok

    What could  happen with the other DB??


    Thursday, June 3, 2010 5:03 PM

All replies

  • Hi Cmurillo,

    It might happen because of huge log file of the primary database.

    To know more about the concept of VLF check: Shrinking the Transaction Log http://msdn.microsoft.com/en-us/library/ms178037.aspx

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

    Thanks,

    RajaSekhar Reddy .K

    Thursday, June 17, 2010 10:46 AM
  • hi Cmurillo,

    Also please check the mirror and principal ERRORLOGs for any other error related to this database session between these two databases.

    Sunday, June 27, 2010 10:11 AM
  • I would better understand the time it takes for the update and my threshold for mirror sync.
    Manu Please click the Mark as Answer if my post solves your issue.
    Wednesday, July 7, 2010 8:23 PM
  • reinitialize mirror server
    Tuesday, July 27, 2010 2:21 AM