Agentless, cloud-native backup for Microsoft Azure
Post Reply
scrat
Enthusiast
Posts: 54
Liked: 4 times
Joined: Jul 26, 2022 5:14 pm
Contact:

Azure SQL - Could not export schema and data from database

Post by scrat »

Hi team,
I'm getting the following error on two databases, from different SQL servers.

Code: Select all

[18.09.2024 17:35:38.554] Error    35 (1) Error: Backup operation of DATABASE to REPOSITORY hot has failed: Worker VBA-c0ab86c3-5fd1-4fb3-b89e-440c81af2f83 (10.10.8.13): job completed with error. Error: Could not export schema and data from database.
[18.09.2024 17:35:38.554] Error    35 (1) Error: Worker VBA-c0ab86c3-5fd1-4fb3-b89e-440c81af2f83 (10.10.8.13): job completed with error. Error: Could not export schema and data from database.
Has this happened to anyone? I already have a case with support, #07251460, but just to see if anyone knew how to fix the error or what to check.

Thanks,
Regards.
nielsengelen
Product Manager
Posts: 5883
Liked: 1232 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Azure SQL - Could not export schema and data from database

Post by nielsengelen »

Hi,

I removed a part of your code snippet, and only kept the error you receive, as this is not a support forum. Please continue working with support as every issue is different and may have different solutions.
GitHub: https://github.com/nielsengelen
NAP-LN
Influencer
Posts: 10
Liked: never
Joined: Feb 20, 2023 2:11 am
Contact:

Re: Azure SQL - Could not export schema and data from database

Post by NAP-LN »

Hi,

Did support resolve your issue and find the cause?

We have an open case as well for another issue but this started occurring to us as well
scrat
Enthusiast
Posts: 54
Liked: 4 times
Joined: Jul 26, 2022 5:14 pm
Contact:

Re: Azure SQL - Could not export schema and data from database

Post by scrat »

Hey @NAP-LN,
yes, we did:

Change the size of the Large Worker Profile to Standard_F16s and the size of the OS disk to 128 GBs by executing the 'Add Worker Profiles' REST API request (https://helpcenter.veeam.com/docs/vbazu ... kerProfile) with the following body:
{
"minInstances": 0,
"maxInstances": 5,
"osDiskEnabled": true,
"osDiskSizeInGb": 128,
"regionId": "westeurope",
"virtualMachineArchiveType": "Standard_E2_v5",
"virtualMachineSmallType": "Standard_F2s_v2",
"virtualMachineMediumType" :"Standard_F4s_v2",
"virtualMachineLargeType": "Standard_F16s_v2"
}

You can try it and revert if not works.

Good luck,
Regards.
nielsengelen
Product Manager
Posts: 5883
Liked: 1232 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Azure SQL - Could not export schema and data from database

Post by nielsengelen »

If you aren't familiar with using REST, you can also modify the OS and VM type within the user interface.

If you do keep facing issues, please open a specific support case for it and let us know the case ID for future reference.
GitHub: https://github.com/nielsengelen
scrat
Enthusiast
Posts: 54
Liked: 4 times
Joined: Jul 26, 2022 5:14 pm
Contact:

Re: Azure SQL - Could not export schema and data from database

Post by scrat »

You can modify the profile but the "OS disk".
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests