Refresh DEV Azure SQL DB from PROD Azure DB backup

Question

question

VijayKumar768 asked Feb 14, '22 VijayKumar768 edited Feb 16, '22

Refresh DEV Azure SQL DB from PROD Azure DB backup

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.

sql-server-transact-sql azure-sqldatabase-edge

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VishalS · Feb 14 at 10:59 PM

Hi @VijayKumar768,

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.

0 ·

Answer 1 · 2022-02-15T07:29:55.127Z

AnuragSharma-MSFT answered Feb 15, '22 VijayKumar768 edited Feb 16, '22

Hi @VijayKumar768,

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 @VishalS, 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'.

image.png (67.9 KiB)

· 3

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VijayKumar768 · Feb 15 at 06:53 PM

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.

0 ·

VishalS VijayKumar768 · Feb 16 at 02:05 AM

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.

0 ·

VijayKumar768 VishalS · Feb 16 at 10:26 PM

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.

0 ·

question