Post reply

Azure SQL Database

  • 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, 1 month ago by  genova11.

  • 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.

  • 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.

  • December 3, 2019 at 3:51 pm

    #3703867

    Great, thanks for the quick response!!

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

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