Question

How can I run a SQL maintenance plan on demand?

 

Prerequisites

  • Previously created SQL maintenance plans
  • Start the "SQL Server Agent" service

 

Answer

  1. Open up SQL Server Management Studio
  2. In the Object Explorer pane, expand Management
  3. Expand Maintenance Plans

  4. Right-click the desired maintenance plan and click Execute

 

Overview

The purpose of this article is to provide the basic steps to manually run maintenance tasks within SQL Server which is crucial to the success of heavily coded or large databases. A maintenance plan is suggested in our specifications guide. For a custom maintenance plan please contact our services department.