Is it Azure Managed Instance storage having size limit to upload the backup file?

pdsqsql 391

Hello,

I am trying to upload the .bak files from my on-prem Sql Server database backup but it's not letting me to load it.

I tried with smaller Database and that works but trying to even less then 300 MB database size but not working.

Is it Database should be in FULL RECOVERY MODEL or Database FULL backup can also work?

Oury Ba-MSFT 16,901 Reputation points Microsoft Employee

2024-05-17T21:28:34.27+00:00

@pdsqsql Thank you for reaching out and sorry about the issue you are facing.

I would like to see what error message it is giving.?

Regards,

Oury
Oury Ba-MSFT 16,901 Reputation points Microsoft Employee

2024-05-17T21:38:33.31+00:00

@pdsqsql Did you follow this tutorial to upload your bak files.?

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/restore-sample-database-quickstart?view=azuresql
pdsqsql 391 Reputation points

2024-05-17T22:39:04.31+00:00
Thanks Oury.

Failed to upload blob(s) Failed to upload 1 out of 1 blob(s): AdventureWorks2019.bak: error

It's generic message which not providing much information.
pdsqsql 391 Reputation points

2024-05-20T23:53:49.0833333+00:00

Oury,

Let me know if you need another info.

Another question: Is it Database should be in FULL RECOVERY MODEL?
Oury Ba-MSFT 16,901 Reputation points Microsoft Employee

2024-05-21T16:13:34.7966667+00:00

@pdsqsql

The error message you are facing seems more likely to be a network settings or permissions issue. Confirm that you have network connectivity to the Azure Managed Instance. Ensure that you have the necessary permissions to restore databases on the Azure Managed Instance.

2nd question: Both FULL and SIMPLE recovery models can work.

Regards,

Oury
pdsqsql 391 Reputation points

2024-05-28T04:14:54.7166667+00:00

Oury,

Thank you!

Could you please guide me what network settings or permissions I should check?

I can connect Managed instance from SSMS and Azure Data studio.

I also able to see Storage container via SSMS.

I also checked some basic troubleshooting but no luck.

Not sure as everything is new for us so need to some troubleshooting guidelines.

1 answer

UdayMishra-7885 0 Reputation points

2024-05-17T23:54:13.55+00:00
Yes, Azure SQL Managed Instance has size limits for uploading backup files:

Blob Storage: Individual blobs can be up to 200 GB. Use multiple smaller files for larger databases.

Backup and Restore: You can use the RESTORE DATABASE ... FROM URL command with multiple files to handle large backups.

Storage Limits: Managed Instances can support up to 16 TB, depending on the service tier.

Performance: Network bandwidth and performance can affect upload and restore times.

Use striped backups and compression to manage larger backups effectively. Check Azure documentation for the latest limits and best practices.
Please sign in to rate this answer.
pdsqsql 391 Reputation points

2024-05-18T17:35:23.8733333+00:00

Thanks Uday for very good details about size limit.

Actually I have only < 8GB size and also during backup I am compressing so size coming down for actual backup file.

I tried with Multiple files but it's not uploading all the files ( I tried with backing up files to shared folders and uploading to Blob container storage)

I tried to use URL backup but somehow I am hitting error "Operating system error 50 (The request IS NOT supported.)”

I have also created Shared access key and then tried to take backup (both way - straight backup and with stripping multiple files)

2nd question: Is it Database should be in FULL RECOVERY MODEL?

pdsqsql 391 Reputation points

2024-05-21T00:27:09.3266667+00:00

Hello,

I tried first backup of my On-prem DB to Shared Network Folder which is in SIMPLE RECOVERY MODEL an size is around 8 GB and even backup is only 980 MB when I take using Compress.

When I tried to upload the .bak file to my Storage Blob Container, I am getting following error, any idea how I can resolve or troubleshoot it?

Failed to upload blob(s)

Failed to upload 1 out of 1 blob(s): MISqlDB.bak: error

Do I need to Configure anything specials in Advanced section of Blob Storage Container while uploading the file like I have default set up as below:

Blob Type: Block Blob Upload .vhd files as page blobs chekced Block size 4 Mib Access Ties: Hot Encryption Scope: Use Existing Default Container Scope

pdsqsql 391 Reputation points

2024-05-24T20:53:27.7733333+00:00

Hello,

Can someone help out as having issue while uploading the file in Azure Storage Blob container?

I have backup taken of on-prem DB which is in Full recover model, DB size is around 900 MB but when I tried to upload the .bak file it's throwing following error, I also tried to split the files in Multiple files but still same issue:

Is it permission issue or any network issue?

I have owner role on storage account.

Failed to upload blob(s)

Failed to upload 1 out of 1 blob(s):

SqlDB.bak: error

I tried with using my on-prem sql server and it also having an issue:

I have created SAS token using READ/WRITE/LIST permission, there are no '?' in my token btu I tried to take a backup to store into Storage Blob container URL, it's also throwing an error:

"Operating system error 50 (The request IS NOT supported.)”

Thanks for your help, appreciated it!

Oury Ba-MSFT 16,901 Reputation points Microsoft Employee

2024-05-24T22:57:48.7266667+00:00

@UdayMishra-7885Thank you for reaching out. You mentioned that you have an owner permissions but you might still need to check if your SAS is correctly configured. https://learn.microsoft.com/en-us/azure/storage/common/storage-sas-overview

If the issue persists, I suggest creating a support ticket so we can take a closer look.

Regards,

Oury

pdsqsql 391 Reputation points

2024-05-25T00:27:09.5866667+00:00

Thanks Oury for the link.

SAS is looks like configured correctly.

I have set up expired after 1 year, there is no '?', Azure Storage services is Blob storage, storage account has all permission access like READ, WRITE, DELETE, LIST etc, SAS creation has the start time, expiry time, and permissions are specified in the SAS.

Appreciate your further help as I can't move further as I need to restore the database also.

Oury Ba-MSFT 16,901 Reputation points Microsoft Employee

2024-05-28T20:06:48.9733333+00:00

@UdayMishra-7885

According to this doc https://learn.microsoft.com/en-us/sql/relational-databases/tutorial-sql-server-backup-and-restore-to-azure-blob-storage-service?view=sql-server-ver16&tabs=SSMS

SQL Server 2012 SP1 CU2 introduced support for back up to Azure Blob storage. SQL Server 2014 and prior does not support the Shared Access Signature (SAS) that is described in the above QuickStart article.

If all if the above requirements were met and you are still not able to connect. I would suggest raising a support ticket so we can further assit.

Regards,

Oury
Sign in to comment

Share via

Is it Azure Managed Instance storage having size limit to upload the backup file?

1 answer