Recovering a remote SAP database server from a disaster

Recovering a remote SAP database involves re-installing the Microsoft Windows operating system and restoring files from a recent backup.

To recover a remote SAP database server from a disaster

  1. Re-install the Microsoft Windows operating system on the SAP database server.

    During the re-install process, install Windows into a temporary directory that you can delete after your SAP database server is back up and running.

  2. At the media server, and using the storage media containing the FULL flat file SAP database server file system backup, restore the entire contents of the media to the SAP database server using Backup Exec.

  3. Reboot your SAP database server.

    The computer reboots using its original version of Windows. The system contains the original version of Windows, the SAP Agent, the SAP database minus the tablespaces, and any other files contained on the full backup media.

  4. If you have a full offline SAP database backup, restore your last full offline SAP database backup and start your database.

    If you do not have a full offline database backup, your database is operational. Proceed to step 5.

  5. Restore the backint.xml file from the latest full server backup.

    The backint.xml file correlates the SAP catalog with the Backup Exec catalog.

  6. To bring your database up-to-date, restore your most recent online or offline SAP database backup.

  7. At the media server, run another restore operation. This time, use the SAP Agent to restore the storage media containing all of the SAP tablespace data files.

  8. When the restore operation completes, open the CCMS console, and click Check and Repair Database.

  9. Click Automatic Recovery, and then follow the online prompts.