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!
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!