In this article, we are going to configure a maintenance place on the SQL Server 2017 instance installed locally. Maintenance Plans are used in SQL Server to easily configure and automate tasks that keep the database instance in shape. Today’s demo is executed on a SQL Server 2017 instance however, Maintenance Plans are still relevant in SQL Server 2022. This is a real live demo from start to finish so we shall mention some bottlenecks you might face in the wild attempting this process.
You can learn more about Maintenance Plans in Microsoft’s documentation here: Maintenance Plans.
First Attempt at