When restoring an Azure portal SQL database, an instance is created as the current DB

Question

When restoring an Azure portal SQL database, an instance is created as the current DB.

I set the restore point to a week ago, entered a new instance name, and restored the DB.

But the new instance has the rows created today.

Do you know why this is?

Answer 1

You make sure your database backup settings supports the period you are trying to restore in point-in-time restore.

refer: https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure?view=azuresql&tabs=portal#create-long-term-retention-policies

I recommend you to go through the Point in time restore procedure described in the below link and verify whether you are doing everything right.

https://learn.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups?view=azuresql&tabs=azure-portal#point-in-time-restore

Hope this helps