Unrestored Log in Database Mirroring History RRS feed

  • Question



    I want to know what is unrestored log in Database Mirroring History


    While reviewing the mirroring status using database Mirroring monitor we have seen some unrestored logs in the monitor

    Actually the records are as below


    Time Recorded         Role              Mirroring State             UnsentLog             Time to Send          UnrestoredLog  




    11/10/2008 12:57:22 Principal         Synchronizing                 202154KB          00:07:01                  0KB

    11/10/2008 12:57:00 Principal         Synchronizing                 0KB                                                 51636KB

    11/10/2008 12:56:52 Principal         Synchronizing                 216540KB          00:06:01                  0KB



    Please help me out. does the mirroring got affected and it loses some datas??????. I am getting like this at several intervals. Please advice me..

    Thursday, November 13, 2008 12:01 PM


  • It meens that the principal has 'log' to send over the network and that the mirror has nothing to restore. This meens that the network is your bottleneck (the mirror is up to date with what was sent by the principal).


    Thursday, November 13, 2008 4:08 PM