Top "Maintenance-plan" questions

A Maintenance plan is any variety of scheduled maintenance to an object or item of equipment.

SQL Maintenance Cleanup Task Working but Not Deleting

I have a Maintenance Plan that is suppose to go through the BACKUP folder and remove all .bak older than 5 …

sql-server sql-server-2008 maintenance-plan
How often should the indexes be rebuilt in our SQL Server database?

Currently our database has size 10 GB and is growing by around 3 GB per month. Often I hear that one should …

sql-server indexing sql-server-2005 maintenance-plan
Maintenance Plan Execute option is greyed out

When I go to SQL Server Management Studio -> Management -> Maintenance Plans -> Right click on …

sql-server sql-server-2012 maintenance-plan
Change SQL Server Maintenance Plan Report Location?

I created some Maintenance Plans in SQL Server 2008 without using the wizard (i.e. right-click on Maintenance Plans and select …

sql-server-2008 maintenance-plan
SQL Server: should I use an "Agent Job" or a "Maintenance Plan" to delete old data?

I'm looking for a way to periodically (e.g. weekly) run some SQL statements in a database to delete old …

sql-server sql-server-2005 sql-server-agent maintenance-plan
SQL Maintenance Plan - End Task

Is there any way to stop a maintenance plan after it has been triggered? I have one that is running …

sql sql-server maintenance-plan
E-mail Operator only on Maintenance Plan Failure

I know you can use Reporting and Logging wizard to setup a report e-mail for a maintenance plan, but is …

sql-server email maintenance-plan