Schedule Backup issue using Enterprise Manager

I have set up EM to back up several databases on a machine running Win2k
Advanced Server and SQL Server 2000 SP2. On each db, I right click and
created a backup task and set a reoccurring scheduled time for daily back
ups. What's weird and someone frustrating is that the tasks ALWAYS append
existing data which makes the backups unnecessarily large and the scheduled
time never sticks. I'll go in a click Overwrite Existing Data and set the
back up time each day and it never says these changes. I've even tried to
remove the task(s) and create new ones from scratch and it won't let me
remove the old ones. Each day, it appends the existing data and the
scheduled time is never there (even though the auto backups do occur...not
sure why).
So...each and every day, I have to go and manually backup each db. Not a
huge deal but a bit frustrating since EM should do this for me. Any ideas?
Is this a known issue?
TIA!
-S
If you use Enterprise Manager and the Backup Database task
by right clicking on a database, this will create a job
named something like YourDatabase backup
The job will have a T-SQL step that will execute the T-SQL
backup statement that was generated when you scheduled the
task. If you need to make changes, you need to modify the
job rather than trying to go back in through the task part
of Enterprise Manager.
You can modify the schedule from the schedule tab of the
job.
If the job was initially created to append, the backup
command in the job step with include WITH NOINIT. You can
change this to WITH INIT if you want to overwrite the
backups. You can find more information on the BACKUP
DATABASE statement that is generated and it's options in
books online under backup.
-Sue
On Thu, 13 Jan 2005 09:41:29 -0500, "D. Shane Fowlkes"
<shanefowlkes@.h-o-t-m-a-i-l.com> wrote:

>I have set up EM to back up several databases on a machine running Win2k
>Advanced Server and SQL Server 2000 SP2. On each db, I right click and
>created a backup task and set a reoccurring scheduled time for daily back
>ups. What's weird and someone frustrating is that the tasks ALWAYS append
>existing data which makes the backups unnecessarily large and the scheduled
>time never sticks. I'll go in a click Overwrite Existing Data and set the
>back up time each day and it never says these changes. I've even tried to
>remove the task(s) and create new ones from scratch and it won't let me
>remove the old ones. Each day, it appends the existing data and the
>scheduled time is never there (even though the auto backups do occur...not
>sure why).
>So...each and every day, I have to go and manually backup each db. Not a
>huge deal but a bit frustrating since EM should do this for me. Any ideas?
>Is this a known issue?
>TIA!
>-S
>