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