Search This Blog

Friday, May 22, 2009

SQL Admin: How to modify scheduled backup database maintenance plan

Issue:
How to modify scheduled backup database maintenance plan?

Resolution:
1. Connect to SQL 2005
2. under Management, expand Maintenance Plans
3. Right Click te Maint Plan
4. Click Modify

This will show you the Maintenance Plan Details/Properties

In the right side you will see the Maintenance Plan Tasks, where you can see the 'Maintenance Plan Tasks',
'Back up database Task' is one of the options where you can set the back up process of the database.

In the left side of the window, sub plans are listed. If you're back maintenance plan is already existing, select the Back Up database sub plan to modify it.

No comments: