Backup and Recovery
You need to regularly back up your operating system and database to recover them in case of any failure. Amazon provides various services and tools that you can use to back up your SQL Server database of SAP applications.
Amazon Machine Images (AMIs)
You can use the Amazon Web Services Management Console or the Amazon CLI to create a new AMI of your existing SAP system. This AMI can be used to recover your existing SAP system or to create a clone.
The Amazon CLI create image
command creates a new AMI based on an existing
Amazon EC2 instance. The new AMI contains a complete copy of the operating system and its
configuration, software configurations, and optionally all Amazon EBS volumes that are attached
to the instance. For details on how to create an AMI of an existing Amazon EC2 instance, see
Creating an Amazon EBS
Backed Windows AMI. AMI creation and lifecycle can be centrally managed in
Amazon BackupAmazon Backup.
Amazon EBS Snapshots
You can back up your Amazon EBS volumes to Amazon Simple Storage Service by taking point-in-time snapshots. Snapshots are incremental backups, which means that only the blocks on the device that have changed after your most recent snapshot are saved.
Snapshots are suited to back up SAP file systems like /usr/sap/*
, /sapmnt/*
. If you decide to take snapshots of your EBS volumes
containing data and log files, make sure to use Volume Shadow Copy Service
The following command creates a snapshot of volume (with example volume id
vol-1234567890abcdef0
). You can use this command in Amazon CLI to create your own
volume snapshot.
aws ec2 create-snapshot --volume-id
vol-1234567890abcdef0
--description "This is my volume snapshot."
Database Backups
For SQL Server database backup, you can use one of the following methods:
-
SQL native tools to take backup on disk: Backup requires high throughput compared to IOPS. We recommend using Throughput Optimized HDD (st1)
which provides maximum throughput of 500 MB/s per volume. Once the backup completes on disk, you can use scripts to move it to an Amazon S3 bucket. -
Amazon Backup for application-consistent backups via Microsoft’s Volume Shadow Copy Services (VSS). Ensure that the flag in the advanced backup settings is enabled:
-
Third-party backint tools: Partners like Commvault, Veritas, and so on use SAP backint interface and store backups directly in Amazon S3 buckets.