Blog Post

Azure Database Support Blog
1 MIN READ

Lesson Learned #281: Export fails due to system out of memory exception

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Jan 13, 2023
We found today an out of memory exception raised by SQL Server Management Studio exporting a database. This exception may occurs because, for performance improvement the export process, this process ...
Updated Jan 13, 2023
Version 2.0
tscamell-vt's avatar
tscamell-vt
Copper Contributor
Oct 27, 2023

Thanks for sharing! I'm hoping this fixes my issue 🙂

 

Please note, the /p:Storage parameter is not supported in the .NET Core (.NET 6) SQLPackage implementations as file-backed models use Esent which would only work on Windows. If you try and use the .NET 6 implementation this will result in the error:

 

*** An unexpected failure occurred: .NET Core should not be using a file backed model..

 

The current workaround is to use the .NET Framework build instead, where the parameter is supported.