Dear all,
I had some issues backing up from an on-premise server to an Azure FILE-SHARE using the Ola Hallengren scripts .
The main issue it didn't work was the difference between an Azure FILE-SHARE and an Azure BLOB-STORAGE.
I was trying to backup to the FILE-SHARE but that is not allowed using the Ola Hallengren scripts ......
Creating the BLOB_STORAGE solved this......
But now I do have a new challange...
Using the Ola scripts the "@CleanupTime" parameter is not allowed !
So how to solve this one....
I found the next Powershell script:
Get-ChildItem –Path "https://blobstorage.blob.core.windows.net/folder/backup" -Recurse | Where-Object {($_.LastWriteTime -lt (Get-Date).AddDays(-30))} | Remove-Item
But this one is not recognize the CREDENTIAL/URL "https://blobstorage.blob.core.windows.net/folder/backup" which I made for backing up to the BLOB-STORAGE (which works fine).
I created an SQL-job on to the same servers to use the CREDENTIALS again but ..... no deletion of the files.
It prompts it does not recognize the HTTP as a path name.
It there another way to delete the files backuped in the BLOB-STORAGE after 30 days????
Regards,
Guus Kramer