Restore an Azure SQL database while retaining backups

gy flag

I'm trying to figure out how to restore a database using the Azure Portal without losing either point-in-time or long-term retention history.

  1. My production database has both a point-in-time and a long-term retention backup schedule

  2. Restore must be to a new database name (can not be the production database)

  3. Renaming the restored database to the production name causes history to be lost

To keep the backup history, the old production database must be kept around. Am I missing a step somewhere?

in flag

Please restore the database on a different logical server with same name as in Production. This way you don't lose backup history of the Production database.

The name of the database is indeed key to retain the point-in-time backups even if you delete/drop the Production database you can use PowerShell to list all available backups as explained here.

I sit in a Tesla and translated this thread with Ai:


Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.