Lots of great ideas but Sam hit it on the head. Set your SQL Maintenance plan to do this. I run incrementals on my Backup folder every night after the Maintenance plan runs so I have my Maintenence Plan set to only keep 2 bak files (that night and the previous night) for each DB. Why do extra work if SQL will do it for you?
Dennis Curious, are these files part of a SQL Maintenance Plan? If so, the maint. Plan should be parsing them I believe... From: Stefan Jafs [mailto:[email protected]] Sent: Tuesday, February 03, 2009 10:32 AM To: NT System Admin Issues Subject: Del *.bak after 7 days I have a bunch of SQL back files that’s keep accumulating, they are backed up to disk and then copied to tape, there is no need to keep more that 7 days on the Hard drives. Does any one have a script / bat file that could del et *.bak from a folder and subfolders after let’s say 7 days? ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
