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 |
|
jrisinger
Starting Member
4 Posts |
 Posted - 2007-03-19 : 15:01:01
|
| Ques; can "both" files the db backup (.bak) file "and" the (.txt)report file in a maint plan object be cleaned up at same time?The object is working ok but trying to setup and match backup text reports to the db, I have way more .bak files than text files.Created from/after db maint plan (which is working ok) from/in the object Maintenance Cleanup Task and the object selections areDelete files of the following type:_backup files_maintenance plan text reportsFile location:_delte specific fileFile name: ___search folder and delete files based on an extensionFolder:__File extension:__File age:_Delete files based on the age of the file at task run time...delete files oder than the following. . . . |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-20 : 00:49:58
|
| Both should run at the same time...Did you check the time stamp of the backup files and mp report files...How much time difference do you see between backup files and report files and number of days to delete the old files are the for both configurations?MohammedU |
 |
|
|
|
|
|
Maint Cleanup Task