Azure SQL managed instance and Azure SQL backups

Question

Deasr ,i have 3 questions please

1-in Azure SQL managed instance ,if i select backup service and i have many databases on this instance can i select only some DBs to take this auto backup by the service and to skip others ?

2-in Azure SQL managed instance , can i make backup plan by my self and to store Azure storage i purchased in case if i don;t neet to have the backup service ?

3-In Azure SQL (not managed instance ) , there is option Single database Is this means i can host only one DB ?

Answer 1

Hi @YasserSaber-0669, welcome to Microsoft Q&A forum.

Please find the answers below:

1. Yes you can configure the backup by selecting appropriate database as mentioned in the below article. You can set the weekly, monthly, yearly retention to 0 days.
   Manage Azure SQL Database long-term backup retention
2. Yes you can create a script that would take backup of Azure SQL Managed Instance and store it on Blob Storage. Below article covers it step by step:
   Database user-initiated backups
3. We can create many databases with different performance levels and add them to single server. Single database says that the compute allocated to the database cannot be shared.

Please let us know if this helps or else we can discuss further.

----------

If answer helps, you can mark it as 'Accept Answer'