PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Restoring a backup that was moved to the cloud using Cloud Tier

An application-aware workflow supports application-aware full backups that are tiered to the cloud using Cloud Tier. This support is available for Amazon Web Services (AWS) and Elastic Cloud Storage (ECS) profiles.

For a Microsoft SQL Server database recovery from backups that have been tiered using an application-aware workflow, the backups must be recalled to the active tier before you perform the recovery.

When you try to restore a backup after an associated full backup has been moved to the cloud using Cloud Tier, the restore operation fails with the following error message:

"reason" : "Missing or invalid value specified for property 'copyId'"

This error occurs when you try to restore either a full backup that has been tiered to the cloud or a tail-log backup when the associated full backup has been tiered to the cloud. For example, the following full and tail-log backups are performed at the specified times:

• FULL1: 10:00 a.m. (in cloud tier)
• TLOG1: 10:30 a.m.
• TLOG2: 11:00 a.m.
• FULL2: 11:15 a.m. (in active tier)
• TLOG4: 11:30 a.m.
• TLOG5: 12:00 p.m.

In this case, the restore of the FULL1, TLOG1, or TLOG2 backup fails with the error message because the FULL1 backup has been tiered to the cloud. The restore of the FULL2, TLOG4, or TLOG5 backup succeeds because the FULL2 backup is in the active tier.

To resolve this issue, contact the PowerProtect Data Manager administrator to recall the associated full backup (FULL1 in this example) from the cloud tier to the active tier, and then perform the restore.