locked
Synching the Mirror RRS feed

  • Question

  •  

    I did the following:

    1. Backup principle DB.

    2. Restored DB to Mirror.

    3. Done some transaction in principle DB.

    4. Activated the Mirror.

     

    Now I was expecting to get an error at step 4, but behold the transaction from step 3 where present in the Mirror DB.

     

    How can this be?

     

    Wednesday, June 18, 2008 8:58 AM

Answers

  • Did you start mirroring before the transactions began ? or did you perform a transaction log backup after the step3, restored in mirror server and then started mirroring ? Could you please elaborate ?

    - Deepak
    Wednesday, June 18, 2008 11:26 AM

All replies

  • Did you start mirroring before the transactions began ? or did you perform a transaction log backup after the step3, restored in mirror server and then started mirroring ? Could you please elaborate ?

    - Deepak
    Wednesday, June 18, 2008 11:26 AM
  •  

    Hi Deepak,

     

    Things were done in the order stated above.  So Mirror was started after transactions completed.  No Tran Log backups performed.

     

    Are you thinking I should have go an error at step 4?  If so I'll test again, maybe the mirror was active before I did the transactions.

     

    Wednesday, June 18, 2008 1:21 PM
  • My apologies Deepak, I do get an error at step 4.  Sorry for wasting your time.  I think what I really did was

     to apply the transactions before I broke the mirror.

    Wednesday, June 18, 2008 2:13 PM