Cannot find LTR backups for Azure SQL Database after the server is deleted

Question

I have set up LTR for an Azure SQL Database and running the Get-AzSqlDatabaseLongTermRetentionBackup -Location northeurope I can see that I have one backup.

After I have deleted the SQL Server and running Get-AzSqlDatabaseLongTermRetentionBackup -Location northeurope again, I can't see the LTR backup. According to https://www.mssqltips.com/sqlservertip/6443/how-to-restore-azure-sql-ltr-backup-after-azure-sql-instance-deleted/ this should be possible.

So what am I doing wrong?

SKU is Basic and DTU i 5...

Answer 1

Hi Tommy Selggren •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you are unable to find LTR backups for Azure SQL Database after the server is deleted.

The timing of individual LTR backups is controlled by Azure. You cannot manually create an LTR backup or control the timing of the backup creation. After configuring an LTR policy, it may take up to 7 days before the first LTR backup will show up on the list of available backups.

If you delete a logical server or a managed instance, all databases on that server or managed instance are also deleted and can't be recovered. You can't restore a deleted server or managed instance. However, if you had configured LTR for a database or managed instance, LTR backups are not deleted, and they can be used to restore databases on a different server or managed instance in the same subscription, to a point in time when an LTR backup was taken.

Similarly if you delete a database, LTR backups are not deleted and are retained for the configured retention period. These backups can be restored to the same server or a different server in the same subscription.

Could you please let us know, were you able to see other backups too before deletion of server?

Also please share the configuration details of the Database and Get-AzSqlDatabaseLongTermRetentionBackup command used for execution in CLI?

Thanks