question

97670328 avatar image
0 Votes"
97670328 asked OuryBa-MSFT commented

Issue restoring sqlazure database from Long term retention using the REST API

I am trying to copy a sqlazure database from long term retention using the documented REST API:
POST https://management.azure.com/subscriptions/{subscriptionId}/providers/Microsoft.Sql/locations/{locationName}/longTermRetentionServers/{longTermRetentionServerName}/longTermRetentionDatabases/{longTermRetentionDatabaseName}/longTermRetentionBackups/{backupName}/copy?api-version=2021-02-01-preview

I am passing all the info correctly but I receive copy is not supported feature in this subscription.
Anything I need to configure in my azure subscription?
I can do it from the portal but not from REST.
I have no issue using PITR restore from REST with no issue. It is just the restore from LTR.

Thanks

Khaled

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

97670328 avatar image
0 Votes"
97670328 answered OuryBa-MSFT commented

Hi Oury,

I do have a support ticket:
TrackingID#2108110010000253

Thanks

Khaled

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Got it Thank you @97670328

0 Votes 0 ·

@97670328 In order this works as suggested you should get the correct Id for the backup and try again, you can use the PS command Get-AzSqlDatabaseLongTermRetentionBackup to get the IDs for backups
more information https://docs.microsoft.com/en-us/powershell/module/az.sql/get-azsqldatabaselongtermretentionbackup?view=azps-6.3.0 [docs.microsoft.com]

Please let support and confirm here if this is resolved.

Regards,
Oury

0 Votes 0 ·