Restore LTR backup after database migrated to Hyperscale edition

This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .


When database migrated from any other edition to Hyperscale and later you attempt to restore your database from LTR backup from the time the database was using another edition the restore operation will fail. 

Submitting the restore will only allow you to use Hyperscale service tier as this was the latest in use. 

However, the LTR backup was taken when the database was using another edition. 


Error messages: 

Restoring a Hyperscale database backup to a non-Hyperscale service tier or vice versa is not supported.



Root Cause:

Azure portal uses the latest edition to decide to which edition to target the restore, in this case it has mismatch in the edition. 



Use command line tool (CLI or PowerShell) to restore your LTR backup and force the correct edition on the restored database. 

The following is a sample using PowerShell restoring database to the same server using Premium P1 as target SLO.


## Restore LTR backup on same server using P1 SLO

$Location = 'WestEurope'
$ResourceGroupName = 'Group'
$TargetSlo = 'P1'

$ltrBackup = Get-AzSqlDatabaseLongTermRetentionBackup -Location $Location | Out-GridView -OutputMode Single

Restore-AzSqlDatabase -FromLongTermRetentionBackup `
    -ResourceId $ltrBackup.ResourceId `
    -ServerName $ltrBackup.ServerName `
    -ResourceGroupName $ResourceGroupName `
    -TargetDatabaseName ($ltrBackup.DatabaseName+"_LTRRestores") `
    -ServiceObjectiveName $TargetSlo 



Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.