4

I want to take backup of Azure sql database to my local system and then restore that backup to Azure sql database in c#. Can any body helps me out?Is it possible to do so?

Improve this question
2

1 Answer 1

Reset to default
1

Azure SQL Database does not support creating .bak files on-demand. Azure SQL DB automatically backups up all databases using native backups to enable you to Point-in-Time restore your database to any point in time within the databases retention period. However, these backups are not exposed and cannot be copied to the local system. To achieve what you want you can export a BACPAC file from a Azure SQL database to the local system using DACFx and also import it into a SQL Azure database from the local system. This article may be of help.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.