Hi All,
We have a requirement where we need to restore back-up of Azure SQL Managed Instance to on-prem. Below are what we are looking for?
1) Can the back-up of Azure SQL Managed Instance database re-stored to any previous version SQL Server on-prem than to on what Managed Instance is currently running on? e.g., Azure SQL MI running on 2022 and on-prem SQL Server version is 2016.
2) If answer to above question is 'Yes', -
- What fallback versions are supported?
3) What are the pros and cons for such approach?
Appreciate your help and response,