SAP Backup and Restore

What is SAP Backup and Restore Procedure?

SAP Backup and Restore: The Sap R/3 Backup consists Database (Differential,Incremental) and Transaction Log (Append,   Overwrite)

Database Backup

Database backup is the core of the R/3 system. This backup is essential to recover the system to the current state.

SAP Backup – T.Log (Transaction Logs)

  • Transaction Logs are critical to the database recovery.
  • It contains a record of changes made to the database which is used to Roll/Back operations.
  • It is critical to have a chain of valid log backup.

SAP Backup – OS (Operating Environment)

Operating Environment

  • Registry
  • System and Network configuration

SAP R/3 files

  • Spool files
  • Transport files
  • Other R/3 related files

SAP Backup – Methodology

  • Backup Strategy can be adopted using three dimension matrix combination:
  • What is backed up, How the backup taken and When the Backup taken?

SAP Database – Full Backup

Merits:

The entire database is backed up at once, making the restore of the database easier and faster. There are less logs that need to be applied to bring the database in the current state.

Demerits:

Takes longer to run than an incremental log backup, bcoz of longer backup window there is more impact on the users while the backup is running.

SAP Backup and Restore

SAP Database – Incremental

Merits:

Much faster than a full database backup, bcoz of the smaller window there is less impact to the users.

Demerits:

  • A full backup is needed, as a starting point to restore the database.
  • To restore the database takes significantly longer and is more complicated than restoring a full backup.

SAP Backup and Restore

SAP Database – Differential

Merits:

The exposure to a corrupt log backup is reduced. Each differential backup is backing up all the changes to the database. Since the last full backup.


Demerits:

  • Like incremental log backup, a full backup is needed as the starting point.
  • The backup window for a differential is longer than a transaction log backup. 

Also See: SAP Hardware Overview

SAP Backup – Offline

Merits:

  • An offline backup is faster than an online backup.
  • During the backup, there is no issue with data changing in the database.
  • If the files are backed up at the same time, the related operating system files will be in sync with the R/3 database.

Demerits:

  • R/3 is unavailable during an offline backup
  • Buffers for R/3 and the database are flushed.
  • This process will impact perform until the buffers are populated.

SAP Backup – Online

Merits:

  • R/3 is available to users during a backup.
  • The buffers are not flushed.

Demerits:

  • An online backup is slower than an offline backup
  • Backup time is increased because processes such as R/3 are running and competing of system resources.
  • Online performance is degraded while the backup is running.
  • Data may change in the database while it is being backed up.

Also See: SAP System Monitoring Transaction Codes

Online Training Tutorials

  • System LandscapeDefine System LandscapeThe purpose of this activity is to establish the system landscape. The system landscape consists of the SAP Systems and clients that will enable you to adapt the SAP standard software to […]
  • SAP BASIS Transaction CodesSAP BASIS Transaction Codes ListsHere you find SAP basis transaction codes and with functions and usage with short description. User Overview: Display all the users who are currently logged on to the system and show […]
  • SAP BASIS Interview Questions and Answers for FreshersSAP BASIS Interview Questions and Answers for Freshers – TechnosapSAP Basis is like an operating system for R/3. It sits between the ABAP/4 code and the computer's operating system. We have listed of SAP Basis interview questions and Answers that have […]
  • SAP BASIS Interview Questions and Answers for FreshersSAP Basis Tutorial for Beginners -Learn SAP Basis OnlineThese SAP basis Tutorial assume that you have some basic knowledge of SAP Basis modules. SAP Basis refer to administration of SAP system that includes different transactions include […]
  • Types of Work Process in SAPTypes of Work Process in SAPEven though the work processes are unique at OS level SAP differentiated between the work process based on the nature of work. The work process are determined by the instance name […]
  • What is Client Copy in SAP Step by StepA client copy does not "generate a new system". It is used to transfer information between clients within the same system or to another system at the same release and db level. Client […]
  • R3 ArchitectureMain Components of R/3 ArchitectureComponents of R3 Architecture Database Server The database server is the most powerful server in an R/3 system. R/3 uses the database management system as central storage for all R/3 […]
  • SAP Support PackageThe Steps to Upgrade SAP Support PackageHope sometimes we need to update our SAP Support Package for bug fixing or regular maintenance. If we  check our current SAP Support Package Level from transaction SPAM --> Package […]