Azure SQL Database

  • genova11

    SSC-Addicted

    Points: 428

    I have taken over responsibility of an Azure SQL database. I want to make a true one time backup of this database. By true I mean that if I lost the database I could restore it and it would look exactly like it did before. When I go into SQL Server Management Studio (version 15.0.18142.0) I select the database I want to backup. When I right click on the database and select 'Tasks', I do not see an option for backup. I do see an option for 'Export Data-tier Application' (which creates a .bacpac file). I chose this option and created a .bacpac file. Is this .bacpac file a 'true' backup of my database? True meaning if I lost my database I could restore it from this file and it would be the same as it was before.

    Thanks.

    • This topic was modified 1 week, 1 day ago by  genova11.
  • genova11

    SSC-Addicted

    Points: 428

    I am sorry. I am going to move this post to SQL Server 2012. I should not have put it in here.

  • debasis.yours

    SSCrazy

    Points: 2828

    Hi,

    Yes, a .bacpac file can be used as a true backup for azure SQL database.

    Thanks.

  • genova11

    SSC-Addicted

    Points: 428

    Great, thanks for the quick response!!

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply