Solution : https://service.sap.com/sap/support/notes/965908 (SAP Service marketplace login required)
Summary :
This SAP Note delineates the procedures for integrating Database Mirroring, introduced in SQL Server 2005 and optimized in subsequent versions, with SAP applications. It covers setting up, configuring, and monitoring database mirroring alongside pertinent SAP adjustments for effective performance. Key aspects include synchronous and asynchronous mirroring modes, their operational nuances, and the implications for SAP’s transaction handling and system availability. Details are given on configuration changes necessary in SAP profiles and the importance of a failover strategy supported by a Witness server for automatic operations. The note emphasizes careful planning and design to harness the full potential of database mirroring in high-availability environments.
Key words :
guarantee transaction log backups taking place, sap j2ee engine config tool, sap work process developer traces, /technet/prodtechnol/sql/2005/technologies/dbm_best_pract, pflthe parameter dbs/mss/server, database=<dbname> dbs/mss/server=<principal>, deploying database mirroring solution database mirroring, monitoring database mirroring monitoring database mirroring, sap abap application server based logic, database mirroring monitoring database mirroring considerations
Related Notes :
| 1550337 | Database Mirroring causes blocking application instance |
| 1297986 | Backup and Restore strategy for MS SQL Server |
| 1101017 | Log shipping on SQL Server 2005 |
| 639702 | JDBC Driver for Microsoft SQL Server |