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 |
|
debug
Starting Member
29 Posts |
 Posted - 2003-06-22 : 11:21:09
|
| Hi Folks,I am facing a problem in automating the deletion of Log files which are created by the Logs of Maintenance Plans which I have created. Please let me know if someone has such a Batch File which deletes 7 days old log files from the Disk drive.regards,DU |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-22 : 13:30:37
|
| I don't use maint plans (and think no one should) but include in the backup SP commands to clear up too old files.seehttp://www.nigelrivett.net/BackupAllDatabases.htmlYou can use the same method to delete your logs.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Batch File to delete one week old Maint.log files