Restoration of hyperscale database

Sai Theja 21 Reputation points
2022-08-26T06:41:18.673+00:00

Recently, we have migrated our Database from business critical tier to hyperscale tier.

But when we wanted to have a point in time restoration DB of before migration, unable to take backup.

throws error as the destination DB is mismatched to the current DB.

Kindly help me on backup.

Note:Retention of DB is 35 days.

Azure SQL Database
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 27,002 Reputation points Microsoft Employee
    2022-08-26T15:59:53.04+00:00

    Hi, @Sai Theja Welcome to the Microsoft Q&A forum, and thanks for reaching out.
    There shouldn't be any issue in changing the Service tier, regarding the restoration retention will be 35 days from the point of creation of DB in Hyperscale, How did you restore from the portal? please share more details. also please try from the CLI.
    please refer to this document for more information on PIT restore.

    Regards
    Geetha


  2. Sreeju Nair 11,601 Reputation points
    2022-08-26T17:21:13.713+00:00

    See the below from the documentation.

    For databases migrated to Hyperscale from other Azure SQL Database service tiers, pre-migration backups are kept for the duration of backup retention period of the source database, including long-term retention policies. Restoring a pre-migration backup within the backup retention period of the database is supported via the command line. You can restore these backups to any non-Hyperscale service tier.

    Refer: https://learn.microsoft.com/en-us/cli/azure/sql/db?view=azure-cli-latest#az-sql-db-restore
    https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale?view=azuresql#known-limitations

    Hope this helps

    0 comments No comments