How automate backup and restore in Azure SQL Managed Instance?
0
votes
2
answers
413
views
I'm the DBA of one Azure SQL Managed Instance and one of our clients asked us if is possible automate a backup and restore in order to have a copy of one of the database before one of our ETL procces start.
That's because they want to do all insertions and work on the copy database instead of the main production database and after finish everything and if data validations are OK, change database name.
So I thought use a SQL Job just for backup a database to one blob storage and then restore using a backup file from a blob storage, the problem start when I realized that could not use a proxy account (related to the credential with access to blob storage)in the SQL Job and also there are some limitations in TSQL (WITH CREDENTIAL for example)
Now with those restrictions I don't know how can automate this task.
If I am not wrong, ELASTIC JOBS are only for Azure SQLDatabase
Thanks in advance
Asked by SakZepelin
(21 rep)
Feb 22, 2024, 09:29 PM
Last activity: May 25, 2025, 11:04 PM
Last activity: May 25, 2025, 11:04 PM