Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kensai
Posting Yak Master
172 Posts |
 Posted - 2010-08-24 : 04:56:28
|
I have the following backup and delete job: What I want to do is have only one backup file per database. I've created a cleanup job but currently I have 4 backup files per database so I assume I made something wrong. What should I do? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-08-24 : 17:13:30
|
| The task you included does not cleanup the backup files - it cleans up the history tables in MSDB. You need to add the maintenance cleanup task and configure that to cleanup the files. |
 |
|
|
kensai
Posting Yak Master
172 Posts |
Posted - 2010-08-27 : 02:57:31
|
quote:
Originally posted by jeffw8713
The task you included does not cleanup the backup files - it cleans up the history tables in MSDB. You need to add the maintenance cleanup task and configure that to cleanup the files.
Thank you, this was what I was looking for. |
|
|
|
landuan
Starting Member
3 Posts |
Posted - 2010-08-30 : 05:44:29
|
| <spam removed> |
|
|
|
|
|
|
Maintenance Backup doesn't clean