Azure Backup
An Azure backup service that provides built-in management at scale.
1,244 questions
How can fix LongTermRetentionBackupInternalError
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 2%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYY%3C/text%3E%3C/svg%3E)
Youssef Yassa
25
Reputation points
I am trying to make a backup to Azure database Postgres SQL flexible server but it fails and gives me this error LongTermRetentionBackupInternalError I followed https://video2.skills-academy.com/en-us/azure/backup/backup-azure-database-postgresql-flex but still give me same error can some one help me please?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 33%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Anderson Leite 10 Reputation points2024-08-15T08:07:53.7233333+00:00 I'm facing the exact same issue, some support from MS would be nice
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 12%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Koen de Jaeger | Finalist 5 Reputation points2024-08-23T10:37:06.0666667+00:00 Same here , in region westeurope, when enabling high availability.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 47%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Pol Valverde 0 Reputation points2024-08-28T10:21:39.1166667+00:00 - Same here in region westeurope with High availability not enabled in my case
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 22%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKT%3C/text%3E%3C/svg%3E)
Karen Turner (Catalyst) 0 Reputation points2024-09-03T01:01:17.18+00:00 I was getting this error.
I set the backup instance in the Azure console and it assigned the roles for me.
But then I redid it in Terraform using Azurerm resource and got it to allocate a system assigned identity and two roles one scoped for reader for the resource group, and one for long term backup for the flexible db server. And that fixed it for me.
-
Anderson Leite 10 Reputation points
2024-09-03T07:45:21.8333333+00:00 I also have the same roles to reader at RG and Long Term Backup to the server, but I'm unable to make this work. At server I have a
UserAssignedidentity.@Karen Turner (Catalyst) how did you manage to add a system identity to the PSQL Flexible Server ? On TF resource page (https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/postgresql_flexible_server) it mentions the only possible value to this as
UserAssigned:An
identityblock supports the following:-
type- (Required) Specifies the type of Managed Service Identity that should be configured on this PostgreSQL Flexible Server. The only possible value isUserAssigned.
-
-
Pol Valverde 0 Reputation points
2024-09-03T15:47:40.6933333+00:00 I have the backup set with a weekly policy, and it magically worked this week. Maybe someone at Azure fixed something? I'm not sure if you all are still encountering the same error.
-
Anderson Leite 10 Reputation points
2024-09-03T15:59:16.0766667+00:00 After @Pol Valverde comment, I went back to check my backup vaults which was in a failed status for PSQL Flexible Servers, and... It magically started to work since September 1st:
Sign in to comment
Sign in to answer