SQL Server DBA

Ola Hallengren Maintenance Solution

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.

This is 21 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples