How to delete Old database backup files from Azure blob container through Using T-SQL script without using any Azure CLI and PowerShell commands.

Question

How to delete Old database backup files from Azure blob container through Using T-SQL script without using any Azure CLI and PowerShell commands.

Srinivas Naraipeddi 40

Here is the corrected version of your sentence:

We are facing an issue with deleting old backup files from the Azure Blob container. Our company is not willing to spend money on this deletion activity. Please let me know how to delete old database backup files from the Azure Blob container using only a T-SQL script, without using Azure CLI or PowerShell commands.
Server Details : Azure Managed Instance Tier : General

Olaf Helper 47,436 Reputation points

2025-06-03T10:21:43.5466667+00:00

using only a T-SQL script

T-SQL is to modify and query data, not for Azure operation like file/BLOB deletions.

1 answer

Your answer

Olaf Helper 47,436 Reputation points

2025-06-03T10:21:43.5466667+00:00

using only a T-SQL script

T-SQL is to modify and query data, not for Azure operation like file/BLOB deletions.

Answer 1

Erland Sommarskog 121.4K MVP Volunteer Moderator

"I'm in London and I want to go New York. I don't want to fly or take a boat. Please let me know how I can go to New York by car".

As Olaf says, T-SQL is not for managing Azure Blob store. You could write a CLR procedure that you call for the task, but that's more complicated than using CLI or Powershell (and neither of them would cost anything particularly.)

The alternative would be to go use something like Azure Storage Explorer and delete the files manually. That's free software as I recall.

Share via

How to delete Old database backup files from Azure blob container through Using T-SQL script without using any Azure CLI and PowerShell commands.

1 answer

Your answer