SAP Database Backup and Restore Solutions for HP StorageWorks Enterprise Virtual Array Using HP Data Protector 6.1 Software
An important requirement for SAP customers is the creation of back up SAP databases that can be done as fast as possible and does not affect the production system. This is particularly important for SAP customers who require 24 x 7 availability even in mid-sized environments. HP Data Protector 6.1 software in test environments has been used by HP to validate a range of backup solutions. These backup solutions come with an SAP application that is used along with a Microsoft SQL Server 2005 database. HP StorageWorks Enterprise Virtual Array (EVA) storage was also used with different backup devices. This paper suggests that the fastest database backup solution that will have the least effect on the SAP application is Zero Downtime Backup (ZDB). ZDB comes with an HP StorageWorks 6000 Virtual Library System (VLS6000). This paper has been intended to help SAP system administrators and provide suggestions for backup and restoration solutions. The objectives of these backup and restore solutions included validating solution components - SAP ERP 2005, SQL Server 2005, and Data Protector 6.1. It also includes EVA and HP StorageWorks Command View for Tape Libraries (CV-TL). Another objective of the paper is to assess the ability of the solution to backup and restore an SAP database using a range of backup devices. Test scenarios in the paper include local and network backups, ZDB, and backups with Microsoft VDS or Volume Shadow Copy Service (VSS). The paper discusses the hardware and software components of the solution in detail.