Changing backup type from append to overwrite
Posted on 2006-07-02
I have an SQL server with around 15 databases that have been setup with individual backup jobs for each day of the week - so there are around 75 backup jobs.
The backups are set to backup to disk, these files are then separately backed up to tape. Each database is backed up to a file for the day so that they can go back 5 days without having to go to tape.
The person who set the jobs up chose the append option rather than the overwrite option, and the server is now running out of disk space.
Is there any way to change an existing job to overwrite rather than append.
The code in enterprise manager doesn't seem any different either way:
BACKUP DATABASE [EXAMPLE] TO DISK = N'D:\BACKUP\EXAMPLE\FRIDAY\EXAMPLE' WITH INIT , NOUNLOAD , NAME = N'EXAMPLE FRIDAY backup', NOSKIP , STATS = 10, DESCRIPTION = N'EXAMPLE FRIDAY backup', NOFORMAT
I would rather find a nice way to change it rather than having to reschedule 75 jobs for them.