June 21, 2022 at 11:51 am
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
June 22, 2022 at 12:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
June 24, 2022 at 10:16 am
Found this on deleting old items on blobstorage like implementing a policy
June 24, 2022 at 1:09 pm
I've had my Azure dev write an Azure Logic App to remove files of a given container path after 30 days.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy