Stopped Using SQL Managed Backup from Azure but SQL still trying to perform backup

Simon Scott 0

We have moved backups away from Azure, and turned off the automated managed SQL backups from within the Azure portal. The blob storage that the backups were going to have been deleted. SQL is still trying to back up some of the databases, I have managed to at least pause the backups for the moment, but I am trying to disable the backups completly as they are nuking our server resource as they cant complete. i have followed the instructions https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/disable-sql-server-managed-backup-to-microsoft-azure?view=sql-server-ver16 here but keep gtting errors as the blob storage no longer exists. How can I disable the backups from within SQL. There is no job under the agent and no managed task.

Oury Ba-MSFT 18,696 Reputation points Microsoft Employee

2024-02-15T19:37:18.85+00:00
@Simon Scott
Thank you for reaching out. Did you run the below code already.?

EXEC msdb.managed_backup.sp_backup_config_basic @database_name = 'YourDatabaseName', @enable_backup = 0;
Oury Ba-MSFT 18,696 Reputation points Microsoft Employee

2024-02-20T20:40:08.2333333+00:00

@Simon Scott Still facing the same issue.? Could you please file a support ticket. Regards, Oury
Simon Scott 0 Reputation points

2024-02-21T07:30:59.0566667+00:00

@Oury Ba-MSFT Yes unfortunatly, I am still facing the same issue, I have managed to temporarily pause the backup from trying. But when I try the above SQL that you posted, I get an error complaining the Blob storage container no longer exists. (which it doesnt as we have moved away from this backup method).
Oury Ba-MSFT 18,696 Reputation points Microsoft Employee

2024-02-23T00:56:37.7833333+00:00

Simon Scott Please let me know if you need help creating the support ticket. Regards, Oury

Share via

Stopped Using SQL Managed Backup from Azure but SQL still trying to perform backup

Your answer