question

DaveFromEngland avatar image
1 Vote"
DaveFromEngland asked AmeliaGu-msft edited

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

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlbertoMorillo avatar image
1 Vote"
AlbertoMorillo answered AlbertoMorillo edited

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.