It depends on how the main. plan is configured. We had a similar occurrence where the plan was set to delete files older than 6 months. That was fine at the beginning but as the db grew, we started running out of disk space. I modified the plan to delete older than 2 weeks.
Paul Chinnery Network Administrator Memorial Medical Center 231-845-2319 _____ From: Sam Cayze [mailto:[email protected]] Sent: Tuesday, February 03, 2009 11:44 AM To: NT System Admin Issues Subject: RE: Del *.bak after 7 days 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? __________________________________________________ Stefan Jafs This email and any attached files are confidential and intended solely for the intended recipient(s). If you are not the named recipient you should not read, distribute, copy or alter this email. Any views or opinions expressed in this email are those of the author and do not represent those of the Amico Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, the company cannot accept responsibility for any loss or damage that arise from the use of this email or attachments. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
