How do I setup a five 9’s SAP on SQL system?

[former_member211576]

Hi experts,

In the SAP teched and Microsoft teched, people talk about a few concerns when building high availability system. For me, it is very difficult to achieve. Is there a best practice or checklist to build a five 9’s SAP on SQL system?

1. www.sapteched.com/sapvweek/presentation/TECH17/TECH17.pdf‎

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/DBI-B318

HA / DR covers many areas -planned as well as unplanned :

-Organizational aspects ( “HA“ of system admin, processes )

-Data Center infrastructure ( e.g. Air condition, power source )

-Servers

-OS ( e.g. patches, upgrades )

-Storage ( e.g. firmware updates )

-Applications ( failure, upgrade, patches )

-Integration of different software systems ( e.g. SAP PI )

-Performance-Security ( DoS attack, ADS )

-Network ( switches / DNS server )

-Clients ( e.g. connectivity to backend )

.....

[Sriram2009 · Accepted solution]

Hi Lee

For HA/DR you may not getting details checklist or document in SAP  it’s not start forward method you may require to refer the SAP installation /system copy guides, some of the few SAP Notes & SCN links

For your reference SAP guide & SCN Important SAP Notes on MS SQL Server

http://scn.sap.com/docs/DOC-8286

https://service.sap.com/instguidesNW70 base on your version (Require for S-user id)

In a year back we have implemented the HA /DR setup in our SAP BI System

from Windows 2003 with MS Sql 2005 (Standalone) to Windows 2008 With MS Sql 2008 R2 (HA /DR environment ) SAP Installation Media - NW 07 SR3

Installation & Configuration steps

1. Exporting the source SAP system

2  Install the windows OS 64 bit enterprise edition with latest patches.

3  Fail over cluster service installation and configurations

4  MS SQL 2008 R2 cluster installation as per the installation guide

5  Central services instance for ABAP installation.

6  Central services instance for JAVA installation.

7  First MSCS node installation

8  Database Instance Installation using backup restore method

9  Additional MSCS node installation

10 Enqueue replication server installations for ABAP in Node I

11 Enqueue replication server installations for JAVA in Node I

12 Enqueue replication server installations for ABAP in Node II

13 Enqueue replication server installations for JAVA in Node II

14Central Instance Installation in Node I

15 Second node installation as per the installation guide

16 Post processing steps after system copy

Thanks

Sriram