September 30, 2024 at 6:32 am
Lets do configure backups in my own in Azure Managed Instance......My Lead has directed me to configure regular backups scheduled as like in traditional SQL Server...Please suggest how to make this possible to create Job that will take backups daily/weekly in Azure Managed Instance.
September 30, 2024 at 3:15 pm
You can, but only "copy_only" backups.
With PAAS solutions (like Azure SQLMI or azure sqldb) you tipically don't have to worry about backups after you have selected (and accepted $$) your backup solution)
Restores are handled using the azure management interface
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
September 30, 2024 at 3:57 pm
Yes , "copy_only" backups would be possible.
But the DBs having enabled with TDE and that TDE enabled databases won't allow us take use of "copy_only" backups.
Please suggest move forward that can be help.
October 1, 2024 at 5:58 am
Why do you manually want to do backups?
Why not let Azure manage the backups for you?
What is the use case / benefit your senior wants to get here?
October 1, 2024 at 11:00 am
The only thing you can do - if you really want your own backup files - is to remove TDE
have a look at "Removing TDE from a Database: Level 4 of the Stairway to TDE"
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
October 2, 2024 at 7:42 am
I want to restore the DBs to another MI in regular intervals as use to do in traditional SQL. Please suggest how to make it possible to schedule automated backups and restores to different MI.
However there would be way to do this by removing TDE , but my seniors won't ready to remove TDE.
October 2, 2024 at 7:50 am
Use powershell and integrate with the Azure (AZ) module to make the Azure backend responsible for doing the restore for you.
You have picked a PaaS offering, let Microsoft do all the maintenance for you.
October 2, 2024 at 9:49 am
I want to restore the DBs to another MI in regular intervals as use to do in traditional SQL. Please suggest how to make it possible to schedule automated backups and restores to different MI.
However there would be way to do this by removing TDE , but my seniors won't ready to remove TDE.
You can restore a database from any sqlmi to another sqlmi within the same subscripition using the Azure Portal
And you can schedule a powershell script that performs these AzureCLI/AzurePowershell calls to do the same for you using some kind of pipeline job in Azure
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 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply