Azure SQL Database

• genova11

  SSC-Addicted

  Points: 434

  More actions

  December 3, 2019 at 3:44 pm

  #3703861

  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 5 years, 4 months ago by  genova11.

• genova11

  SSC-Addicted

  Points: 434

  More actions

  December 3, 2019 at 3:46 pm

  #3703863

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

• debasis.yours

  Hall of Fame

  Points: 3519

  More actions

  December 3, 2019 at 3:49 pm

  #3703865

  Hi,

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

  Thanks.

• genova11

  SSC-Addicted

  Points: 434

  More actions

  December 3, 2019 at 3:51 pm

  #3703867

  Great, thanks for the quick response!!