Skip to Content

DB Mirroring Steps

Hi All,

I am configuring DB mirroring for High Availability of ECC EHP6

here I am following below steps

->install SAP at Mirroring Site

->set the profile parameters according to KBA 965908

->stop AS at mirroring site

->Restore Full Backup of Primary site (With No Recovery Option)

->Restore Log Backup of Primary site(With No Recovery Option)

->Configure DB mirroring from Primary Site using Management Studio

->Enter Witness Site details

->Enter Mirroring Site details

->Start DB Mirroring

Can you please check and let us know if anything I am missing.

Also I have another doubt  regarding automatic failover.

- By doing above steps am I able to connect to Mirroring site when Primary site when down.?

If I want automatic failover what configuration needs to apply from DB and SAP side.

Thank you in advance.

Environment:

OS: Windows 2008 R2

DB: SQL Server 2008 R2

SAP: ECC6 EHP6

Regards

Suresh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 24, 2016 at 03:54 AM

    Hi Suresh.

    1. From the step you have to restore the Ms Sql master db from primary to mirrored site. refer the SAP Note 965908 - SQL Server Database Mirroring and SAP Applications


    2.

    Also I have another doubt  regarding automatic failover.

    - By doing above steps am I able to connect to Mirroring site when Primary site when down.?

    If I want automatic failover what configuration needs to apply from DB and SAP side.

      Refer the SAP Note 965908.

    BR

    SS

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Suresh.

      I think you have to stop the mirroring,

      1. Restore the SAP DB in Mirroring site.

      2. After restored start the MS Sql in single user mode and then restore the master db

      3. Once again do the configure the Mirroring.

      BR

      SS

  • Aug 30, 2016 at 08:01 PM

    Hi Suresh,

    Were you able to finish the completion of the configuration?

    I followed this discussion and so far wanted to know if you could complete the task.

    Best regards,

    Luis

    Add comment
    10|10000 characters needed characters exceeded