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

David 76 Reputation points
2021-04-27T11:00:19.6+00:00

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
    2021-04-27T15:36:37.86+00:00

    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