Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help, Why Won't SQL Let Me Modify This Maintenance Plan?

Status
Not open for further replies.

txdave35

Technical User
Nov 20, 2008
122
US
Hey guys,

We recently moved our SQL 2000 box to a new SQL 2005 server, and I need to add the new databases to the existing 2005 backup maintenance plan.

Please tell me, is there any way to modify the existing plan? I right click and do modify, and it only allows me to change the backup schedule.

Why can't they just have a simple screen where I checkbox the databases that I want to back up? I can't find any documentation on this.

I hope this doesn't mean that I have to delete the entire plan and create a new one. Thanks!
 
Do you have a backup Database task? Can you not right click and edit or is this option N/A?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top