question

MichaelAnderson-3327 avatar image
0 Votes"
MichaelAnderson-3327 asked OuryBa-MSFT commented

Azure Sql Database: Error when trying to restore deleted DB from long term retention

Hi,

I deleted a database yesterday and am now trying to restore it from a long-term retention backup using the Azure Portal.

Go to server
select deleted db
select the db
restore db > changing the setting 'source' - to 'long term retention'
review + create

After 16 seconds the deployment fails with error:

Deployment to resource group 'ResourceGroup' failed.
Additional details from the underlying API that might be helpful: At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/DeployOperations for usage details.

Checking the deployment operations the error message is:

   "statusCode": "Conflict",
   "statusMessage": {
     "status": "Failed",
     "error": {
       "code": "InternalServerError",
       "message": "An unexpected error occured while processing the request. Tracking ID: 'ID'"
     }


The database was in an elastic pool.

PITR restore seems to work, (it's taken 4hrs and still going). I want to use the LTR backup as this is a test.


Many thanks for any help



azure-sql-database
· 1
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.

My suggestion, call Azure Support. It is an internal server error.

1 Vote 1 ·

1 Answer

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered LufeBarreto-2871 commented

@MichaelAnderson-3327 Thank you for posting your question. We are sorry for the issue you are facing when trying to restore a deleted DB from LTR.
Please try to do it using PowerShell script
https://docs.microsoft.com/en-us/powershell/module/az.sql/restore-azsqldatabase?view=azps-4.5.0#examples

Let us know if that works

Regards,
Oury

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

@MichaelAnderson-3327 Checking if you were able to check the above answer I provided. Please let us know the result.

Regards,
Oury

0 Votes 0 ·

@MichaelAnderson-3327 Checking if you were able to check the above answer I provided. Please let us know the result.

Regards,
Oury

0 Votes 0 ·