InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 05:38:54 GMT20http://www.sqlservercentral.com/Forums/Topic804981-146-1.aspxThen I would script something. You can use the Windows Scheduled task to run a VBScript as cscript.exe myscript.vbsas the command. You can set up loops to run through all folders, and then files, leaving the last .Bak only.Tue, 20 Oct 2009 06:55:29 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic804981-146-1.aspx[quote][b]shanila_minnu (10/20/2009)[/b][hr][quote][b]Steve Jones - Editor (10/19/2009)[/b][hr]the name of servers or databases? Are you centralizing backups from multiple servers?VBScript/Powershell might be the easiest way. you can write a script to delete files older than some date.Here's a VBScript sample: [url]http://itknowledgeexchange.techtarget.com/system-administration/vbscript-to-delete-files-in-a-directory-older-than-x-days/[/url][/quote][/quote]ya we are centralizing all the backups to one serverTue, 20 Oct 2009 02:50:44 GMTshanila_minnuhttp://www.sqlservercentral.com/Forums/Topic804981-146-1.aspx[quote][b]Steve Jones - Editor (10/19/2009)[/b][hr]the name of servers or databases? Are you centralizing backups from multiple servers?VBScript/Powershell might be the easiest way. you can write a script to delete files older than some date.Here's a VBScript sample: [url]http://itknowledgeexchange.techtarget.com/system-administration/vbscript-to-delete-files-in-a-directory-older-than-x-days/[/url][/quote]Tue, 20 Oct 2009 02:50:09 GMTshanila_minnuhttp://www.sqlservercentral.com/Forums/Topic804981-146-1.aspxthe name of servers or databases? Are you centralizing backups from multiple servers?VBScript/Powershell might be the easiest way. you can write a script to delete files older than some date.Here's a VBScript sample: [url]http://itknowledgeexchange.techtarget.com/system-administration/vbscript-to-delete-files-in-a-directory-older-than-x-days/[/url]Mon, 19 Oct 2009 08:50:24 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic804981-146-1.aspx[quote][b]bruhaspathy (10/19/2009)[/b][hr]Assuming you have a "BKUP" Directory in Drive K and the backup files are with the extension .bak and you need to delete all files with .bak in that directory.Create a batch file that deletes all the required files.Deleting all files with the extension .bak would need a command such as "DEL K:\BKUP\*.BAK".You need to create the batch file and have it run in a SQL Server Job scheduled daily.[/quote]i have a folder named BACKUp inside that there are many subfolders with the name of servers. so will the command "DEL K:\BKUP\*.BAK" delete all the .BAK file of subfoldersMon, 19 Oct 2009 08:31:55 GMTshanila_minnuhttp://www.sqlservercentral.com/Forums/Topic804981-146-1.aspxThere is a task in the maintenance plans that will do this (maintenance cleanup).Mon, 19 Oct 2009 08:17:31 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic804981-146-1.aspxAssuming you have a "BKUP" Directory in Drive K and the backup files are with the extension .bak and you need to delete all files with .bak in that directory.Create a batch file that deletes all the required files.Deleting all files with the extension .bak would need a command such as "DEL K:\BKUP\*.BAK".You need to create the batch file and have it run in a SQL Server Job scheduled daily.Mon, 19 Oct 2009 07:15:43 GMTBru Medishettyhttp://www.sqlservercentral.com/Forums/Topic804981-146-1.aspxHow are you doing your backups atm, scheduled job or maintenance plans.Mon, 19 Oct 2009 06:49:40 GMTSilverfoxhttp://www.sqlservercentral.com/Forums/Topic804981-146-1.aspxhow can i create a scheduled task to delete some backup files from one folder every day...please can you help me wat command i need to writeMon, 19 Oct 2009 05:55:18 GMTshanila_minnu