Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products

PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

Restoring SQL Server databases to a virtual machine

Learn how to restore Microsoft SQL Server database backups taken in a PowerProtect Data Manager virtual machine application-aware protection policy.

You can restore database full and transaction log backups from the primary DD system or from the secondary DD system if replication is enabled for the PowerProtect Data Manager protection policy. However, when you are restoring from the secondary DD system, the tail-log backup option is not supported.

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 SQL 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.


  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\