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

David 86 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
0 comments
Accepted answer
  1. Alberto Morillo 32,806 Reputation points 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.

    2 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2021-04-27T19:35:10.267+00:00
    0 comments