Feature Request: apply LTR policy at the Server/Instance level (allow to be overridden at the database level)
My assumption is that in the SQL MI preview feature, LTR settings are individually applied on each Database in the instance(powershell commands require both InstanceName & DatabaseName parameters). In the Azure Portal, there is a select-all checkbox, but it just selects all the all databases in the current list.
A scenario where this would be a maintenance headache is when new databases are frequently added to the instance. In this case the LTR policies must then also be applied to that new database. Also consider the case where a database needs to be dropped, then restored again. Does the LTR policy also get dropped and then we need to recreate the policy when the DB is again recreated?