Question
Maintenance Solution on SQL Server or Managed Instance vs. on Azure SQL Database: what gets deployed?
Answer
SQL Server and Azure SQL Managed Instance get the full install: DatabaseBackup, DatabaseIntegrityCheck, IndexOptimize, plus Agent jobs. Azure SQL Database uses a separate script that creates only integrity-check and index/statistics objects, with no backup objects or jobs. Backups there are platform-managed, and SQL Agent is unavailable.