How Can I Bulk Export SQL Databases to Blob Storage Daily Without Admin Credentials?
Asked by
CuriousCoder92
Hey everyone,
I'm looking for a way to export my SQL databases to Azure Blob Storage on a daily basis, but I'm hitting a wall due to MFA requirements with the Entra ID. Currently, I have to export each database from SQL Server Management Studio, which is really time-consuming, especially since there are about 150 databases to handle. To make things more challenging, my company isn't willing to give me SQL admin credentials for easier access.
Has anyone found a workaround for this? I'm quite new to Azure, so any suggestions would really help. Thanks a lot!
Answers
Have you considered using the built-in backup tools in Azure? They can automate the backup process and save you a lot of hassle by running them on a schedule. It might be worth discussing with your team, especially since these tools are designed for this purpose.
Reply to this answer
Add your answer
Answers are reviewed before publication.
CuriousCoder92: We did start a backup policy, but ran into network issues that ended up making the last backup 3 days old, which led to some significant data loss. That's why we're trying this manual export approach for now.