none
DPM with Mirroring (Question 2) RRS feed

  • Question

  • Sorry for reposting this from a previous thread. I think this question needed its own thread

     

    I am not clear on how DPM can work together with SQL Mirroring.

     

    I do express fulls every 6 hours on my SharePoint content DB

     

    1. I do an express full at 12 PM

     

    2. At 5: 55 PM the primary server crashes and there is a storage failure.

     

    3. I fail over to the mirror server at 6 PM

     

    4. I start the server restore on the primary server and it takes 3 hours to rebuilt the entire server. At 9 PM I bring my primary online.

    My understanding is that the server has data as of 12 PM since the last express full was taken then

     

    5. My mirror has data till 9 PM as it has been servicing requests since 6 PM

     

    6. the mirror plays back the logs on primary since 6 PM to 9 PM .... these are the only logs it has

     

    Now my primary and mirror server are out of sync because my primary does not have data from 12 PM to 6 PM.

    Tuesday, September 21, 2010 11:40 AM

Answers