What is the equivalent of a Maintenance Plan in SQL Managed Instance?

David 76 Reputation points

I am connecting to SQLMI via an Azure VM & SSMS.

The maintenance plan folder is missing under Management, even though I have full admin access. What is the process to follow please to allow index maintenance and automated backups in SQLMI?

I can create SQL Server Agent jobs, but also need to delete old backup files after 30 days, so would appreciate a maintenance plan equivalent which always "just worked" for us previously on-prem.

Azure SQL Database
No comments
1 vote

Accepted answer
  1. Alberto Morillo 24,801 Reputation points Microsoft MVP

    Please see the answer I provided on this forum thread. If you connect to Azure Managed Instance using SQL Server Management Studio you won't see any node for maintenance plans as you see on SQL Server instances (IaaS or on-premises).

    You can use Ola's scripts and SQL Agent jobs to schedule maintenance of indexes and statistics for example.

    No comments

1 additional answer

Sort by: Most helpful