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.