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 |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2008-03-13 : 07:38:22
|
| I am relatively new to SQL Server 2005. I have gone ahead and created a maintenance plan which backs up all our databases. This plan is scheduled to run every night. The problem is that each time the plan runs, new backup files are created which quickly uses up valuable disk space. How do I set up SQL Server 2005 to only create one set of backup files and overwrite any existing files when the maintenance plan is run? I tried playing with the "backup set will expire" settings, this did not seem to do anything.....Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-13 : 09:33:42
|
| There is a option in Maintenance plan :Remove files older than: Choose what you want. |
 |
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2008-03-13 : 10:30:49
|
| I do not see any option like that under "Backup Database Task".Under the "History Clean Up Task", I see an option to "Remove historical data older than" option. Is this what needs to be set? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-13 : 22:58:36
|
| It's in maintenance plan clean up task, but it doesn't delete old plan log files. |
|
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2008-03-14 : 07:03:35
|
| Great, found it!Thanks |
|
|
|
|
|
|
Maintenance Plan Help