Can i use preview feature link for SQL MI as DR site (database) for on-prem SQL Server instance?.We don't want to use the SQL MI for reporting purpose. If the answer is yes, if i failover to SQL MI database as primary in case of DR, when original primary onprem SQLDB comes up, can i failback from SQL MI??
The ability to failback to on-prem is only available in SQL 2022. See The Ultimate Freedom of Movement between SQL Server 2022 and Managed Instance - Microsoft Community Hub
Please let us know if you have further queries.