Follow

Run SQL maintenance on demand

Created by: Brendan Bone
Created date:
Last Updated date:

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.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk