Refresh DEV Azure SQL DB from PROD Azure DB backup

Question

Refresh DEV Azure SQL DB from PROD Azure DB backup

Vijay Kumar 2,036

Hi Team,

What is the procedure to Refresh DEV Azure SQL DB from PROD (Backup). We don't want to take a new DB backup. Only planning to use an available backup.

Vishal 1 Reputation point

2022-02-14T22:59:10.787+00:00

Hi @Vijay Kumar ,

Normal backup and restore process can be done as per this documentation. You cannot restore on an existing database. You need to delete the existing database before restoring the database with same name or you can rename the old database to keep it.
In case you want to use SSMS to restore the database you can refer this blog.
Let me know if this is what you are looking for or please share more details about your scenario.

Accepted answer

0 additional answers

Your answer

Vishal 1 Reputation point

2022-02-14T22:59:10.787+00:00

Hi @Vijay Kumar ,

Normal backup and restore process can be done as per this documentation. You cannot restore on an existing database. You need to delete the existing database before restoring the database with same name or you can rename the old database to keep it.
In case you want to use SSMS to restore the database you can refer this blog.
Let me know if this is what you are looking for or please share more details about your scenario.

Answer 1

Anurag Sharma 17,631

Hi @Vijay Kumar ,

Thanks for the ask and using Microsoft Q&A platform .

It seems that you have the requirement to keep on refreshing the data from production database to Development database in Azure SQL.

Adding to suggestion provided by @Vishal , we can use Azure SQL Data Sync to keep the database sync.

SQL Sync data offers the functionality to not only sync the Azure SQL Databases but if we are using the on-premise database it could also be synced. Also multiple databases can be configured if we have multiple environment. We can also schedule it run as per our requirement. Below is the screenshot of providing the sync frequency:

Another way to schedule it is through Azure Automation account. Please go through the below article for the same:

Schedule Data Sync with Azure SQL Database use an Automation account

Using SQL sync will help us in removing any manual effort in long term. I would also request you to go through the FAQs once to know any issues beforehand:

FAQ

Please do let us know if this helps or else we can discuss further on the same. If answer helps, you can mark it ''Accept Answer'.

Vijay Kumar 2,036 Reputation points

2022-02-15T18:53:16.853+00:00

Hi Guys,

What i am looking for is, just restore PROD backup to non-prod. We already have last Friday full backup file. Again we don't want to take a latest backup from PROD.
Vishal 1 Reputation point

2022-02-16T02:05:38.96+00:00

Hi Vijay,

Seems this is one time activity you want to perform. So, I suggest to rename the existing DB and restore the backup on new DB.

Are you seeing any issue doing this?

Thanks.
Vijay Kumar 2,036 Reputation points

2022-02-16T22:26:57.373+00:00

Hi Vishal,

I am not planning to sync data from PROD to non Prod.

It's a very simple question?

Source: AzurePRODDB_backup (This is Production DB backup) I am not touching live prod server, just using existing backup.

Target Server : abc-qa-westus-sqlsrv-01.database.windows.net

Both Prod and non-prod are in different subscriptions.

Share via

Refresh DEV Azure SQL DB from PROD Azure DB backup

0 additional answers

Your answer