Blog Post

Azure Database Support Blog
1 MIN READ

Lesson Learned #300: Exporting a database to storage account that is behind a firewall

Jose_Manuel_Jurado's avatar
Jan 22, 2023

In some situations, we saw that our customers are trying to export their database to a blob storage that is behind a firewall, currently this operation is not supported Export a database to a BACPAC file - Azure SQL Database & Azure SQL Managed Instance | Microsoft Learn

 

Exporting a database we need to review some considerations in terms of storage:

 

  • If you are exporting to blob storage, the maximum size of a BACPAC file is 200 GB. To archive a larger BACPAC file, export to local storage with SqlPackage.
  • Exporting a BACPAC file to Azure premium storage using the methods discussed in this article is not supported.

  • Storage behind a firewall is currently not supported.

  • Immutable storage is currently not supported.

  • Storage file name or the input value for StorageURI should be fewer than 128 characters long and cannot end with '.' and cannot contain special characters like a space character or '<,>,*,%,&,:,,/,?'.

 

Trying to perform this operation you may received an error message: Database export error Failed to export the database: <DatabaseName>. ErrorCode: undefined ErrorMessage: undefined-

Published Jan 22, 2023
Version 1.0
No CommentsBe the first to comment