I need help for Mirroring

[Former Member]

Hi to all,

I'm a DBA and I need hel with SAP Db.

I have 2 Server with SQL and Db SAP are in Mirror.

I need know if there is a procedure if the Db pass in failover over the 2nd Server.

I tried to manually switch the Db on the second server, and remembering and returning from SAP client will not start.

Thanks a lor for your help

Giorgio

[yakcinar]

Hello Giorgio,

I understand that your DB is SQL Server.

If you install your SAP system according to High Available Installation you can easily switch DB from one node to another. With HA option you use MS Cluster.

In you scenario you are using mirroring for HA. When you are using mirroring you should have virtual DNs for your DB Host. Othervise you should change DB host parameter in profile parameters and then try to open SAP.

Regards,

Yuksel AKCINAR

[Former Member]

Hi Yuksel,

Thank you for your answer. That 's what I wanted to clarify

Giorgio B.