locked
Unrestored Log in Database Mirroring History RRS feed

  • Question

  •  

    Hi

    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

Answers

  • 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