Skip to Content
avatar image
-1
Former Member

sap ecc 6.0+MSSQL Databse mirroring issue with error 1412

Sep 08, 2017 at 07:04 AM | 35 Views

Hi Experts,

We have configured DC-DR synchronisation for MSSQL 2008 r2 database. Now due to DR location shift we remove the mirroring between DC-DR. After DR servers are came up we applied logs and tried to reconfigure the mirroring between DC and DR but we are getting below issue..

"The remote copy of database "<SID>" has not been rolled forward to a point in time that is encompassed in the local copy of the database log."

Here i am attaching the screen shot of the issue. Please provide solution ASAP.

Thanksℜgards

Manikanta

<private information removed by moderator -see our rules

untitled.png

untitled.png (109.7 kB)
Microsoft SQL Server
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Luis Darui
    Sep 12, 2017 at 06:49 PM

    Hello dear Manikanta or anyone from "HP Administrator",

    The SAP Q&A is not a ticketing system, we often help others to solve issues, answering questions, etc. Demanding is not a good and nice thing to do when expecting help from others, otherwise, I strongly recommend you to reach out to the SAP Support instead.

    In regards of your case, the clear answer is: recreate the mirroring. Anything beyond that would require further investigation, root cause analysis, etc, and for that, you should contact the support.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Sep 22, 2017 at 07:24 AM

      Hi Luis Darui,

      Thanks for your reply. We resolved the issue by applying transaction logs at DR and reconfigured the mirroring.

      Thanks and Regards

      Manikanta