Deleting older .bak files from Azure Storage Account using PowerShell Script

Question

Deleting older .bak files from Azure Storage Account using PowerShell Script

Victor R 0

Hello,

I have following PS script. Testing for the first time. Bit new to Azure. When I run this I am seeing the error message shown below. Will greatly appreciate your help at the earliest. I am testing from inside a Azure VM (Win2k19 OS) and not from Azure portal.


param($TimerBlob)  
  
$CleanupTime = [DateTime]::UtcNow.AddHours(-168)  
$context = New-AzStorageContext -StorageAccountName "dailysqlbackup" -StorageAccountKey "<Access Key of the storage account>"
Get-AzStorageBlob -Container "dbbackups" -Context $context |   
Where-Object { $_.LastModified.UtcDateTime -lt $CleanupTime -and $_.BlobType -eq "PageBlob" -and $_.Name -like "*.bak"} |  
Remove-AzStorageBlob

Get-AzStorageBlob : Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature. HTTP Status Code: 403 - HTTP

Error Message: Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.
ErrorCode: AuthenticationFailed
ErrorMessage: Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.
RequestId: d4a0417a-e01e-0018-77f9-d522d5000000
Time: Wed, 23 Aug 2023 14:39:22 GMT
At line:6 char:1
+ Get-AzStorageBlob -Container "dbbackups" -Context $context |
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : CloseError: (:) [Get-AzStorageBlob], StorageException
    + FullyQualifiedErrorId : StorageException,Microsoft.WindowsAzure.Commands.Storage.Blob.Cmdlet.GetAzureStorageBlobCommand

Victor R 0 Reputation points

2023-08-24T13:34:43.44+00:00

Duplicate response block.
Sumarigo-MSFT 47,471 Reputation points Microsoft Employee Moderator

2023-09-01T05:16:33.5366667+00:00

@Victor R Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Sumarigo-MSFT 47,471 Reputation points Microsoft Employee Moderator

2023-09-04T14:01:21.42+00:00

@Victor R Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

2 answers

Your answer

Victor R 0 Reputation points

2023-08-24T13:34:43.44+00:00

Duplicate response block.
Sumarigo-MSFT 47,471 Reputation points Microsoft Employee Moderator

2023-09-01T05:16:33.5366667+00:00

@Victor R Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Sumarigo-MSFT 47,471 Reputation points Microsoft Employee Moderator

2023-09-04T14:01:21.42+00:00

@Victor R Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Answer 1

shiva patpi 13,366 Microsoft Employee Moderator

@Victor R

The above error message clearly indicates something is wrong with the authentication.

Can you kindly check if you have copied the storage account key correctly?

I just tried the same script to simulate your issue by providing invalid storage account key:

Once I gave the correct key , the script went through fine...

User's image

Try to regenerate the storage key or use secondary key...

Regards,

Shiva.

Victor R 0 Reputation points

2023-08-24T13:38:10.1333333+00:00

Hi Shiva,

Thanks for your response. I am assuming you are referring to this Access key? I tried both Key1 and Key2 with no luck. I also tried SAS token without success. Other thoughts?
shiva patpi 13,366 Reputation points Microsoft Employee Moderator

2023-08-24T14:10:41.38+00:00

@shiva patpi

Just to test it out , are you able to run successfully from local machine ?

Can you also give me the details of the Virtual Machine and it's networking configuration !!

For the VM , in the networking section - just see if there are any blocking NSG rules

Regards,

Shiva.

Answer 2

Victor R 0

Hello Shiva,

The Access Key is correct. Since I am using Credentials for running backup, if I am using incorrect Access Key in the Credentials, my backup job fails.

Thanks.

Victor

Share via

Deleting older .bak files from Azure Storage Account using PowerShell Script

2 answers

Your answer