Azure SQL Managed Instance - Long term Retention

Mandar Alawani 1 Reputation point
2022-10-13T20:06:13.187+00:00

Hello all,

I can setup LTR policies -PITR, weekly, yearly backups for all existing databases that are created on Azure SQL MI.
However, the policies DO NOT apply for any new databases created after the policy is created. Is there a way to create a default policy that gets
automatically applies to any new database create henceforth.

Thanks,
Mandar

SQL Server on Azure Virtual Machines
Azure SQL Database

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mandar Alawani 1 Reputation point
    2022-10-14T04:24:27.66+00:00

    Sorry, let me explain.

    I want the LTR policies to be in-herited by newly created databases on the same SQL managed instance. That does not happen now.

    0 comments
  2. Bjoern Peters 8,781 Reputation points
    2022-10-14T14:46:36.647+00:00

    Hi @Mandar Alawani

    normally - if nothing goes wrong - the policy will be active for the complete Managed Instance and all of its databases.

    You have read this tip?

    250591-image.png

    Source: long-term-backup-retention-configure

    0 comments
  3. Oury Ba-MSFT 16,156 Reputation points Microsoft Employee
    2022-10-14T18:35:54.487+00:00

    Hi @Mandar Alawani there a no way to create a default policy that gets automatically applies to any new database creation. The Product team are planning to implement that in the future.
    You could create a logic app that runs on a schedule, checks for a new database and then updates the PITR/LTR? Tutorial: Create schedule-based automation workflows using Azure Logic Apps
    Could you please raise this feedback in the Azure feedback for Managed Instance.

    Regards,
    Oury