Create a Maintenance Plan in SQL Server Management Studio
Maintenance Plans allow you to create a workflow of maintenance tasks in SQL Server to ensure your databases are fully optimized and backed up. Plans can be created manually, or by using the built-in wizard, and can be performed manually or automatically on a schedule.
Maintenance Plans are executed as SQL Server Agent jobs. The SQL Server Agent must be running.
To create a Maintenance Plan in SQL Server Management Studio:
- Navigate to Management > Maintenance Plans.
- Right-click Maintenance Plans and choose Maintenance Plan Wizard.
- Rebuild Index
- Backup Database (Full)
The new plan is now listed under the Maintenance Plans node and can be edited at any time. The Maintenance Plan can be run manually by right-clicking and choosing Execute.