SAP on Windows and Microsoft SQL Server System Copy Implementation Guide
Source: www.netapp.com
Topic: SAP Tutorial
Short Desciption:The source database must be exported using SAP tools and imported at ... possible, store the export at a LUN that contains data files of the SAP database. ...
Content Inside: SAP on Windows and Microsoft SQL Server System Copy Implementation Guide SAP on Windows and Microsoft SQL Server System Copy Implementation Guide SAP Competency Center, NetApp May 2007 TR 3586 Executive Summary A guide to configuring and implementing the NetApp System Copy Solution for SAP Windows®/SQL Server in Fibre Channel or iSCSI environments. 2 Table of Contents Business Challenges . 3 NetApp Solution . 3 Technical Implementation. 7 Prerequisites . 7 Installation and Configuration . 7 Executing the System Copy. 8 3 Business Challenges A typical SAP customer environment today consists of different SAP Business Suite and SAP NetWeaver components. To be able to test application patches, run performance and data integrity tests, or provide usertraining environments, copies of SAP components are required. A typical SAP customer needs about 10 copies of different SAP components. These copies must be refreshed, often on a weekly or monthly basis. The creation of a SAP system copy normally takes several days and negatively affects the productive environment. In addition, a lot of manual steps are performed, consuming valuable IT staff time. The source database must be exported using SAP tools and imported at the target system, or an offline backup of the source database will be restored at the target system. Depending on the database size, these steps have a significant impact on the application availability. It takes many hours to replicate a 1TB database from the source to the target system. Preparing the cloned system so that it can be used in the new environment takes several additional hours. This preparation is often done manually, consuming SAP basis administrators time. Being able to create a SAP system copy on demand very quickly is becoming more and more important. Quality insurance systems must be refreshed on a weekly basis. Additional test systems must be set up quickly to perform specific integration tests. Test systems with current productive data ...

