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.
Search This Blog
Friday, May 22, 2009
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment