September 3, 2013 at 11:24 am
Anyone has a script which would delete old backups (7 days old) in each database directory folder. The backups are created via script not by a maintenance plan.
September 3, 2013 at 12:49 pm
Use xp_delete_file eg:
http://www.patrickkeisler.com/2012/11/how-to-use-xpdeletefile-to-purge-old.html
but maybe better will be using a very good script which create and delete old backups http://ola.hallengren.com/sql-server-backup.html
September 3, 2013 at 1:15 pm
Thanks.
September 4, 2013 at 5:09 am
Or you can use Windows utility "Forfiles". I think the syntax varies depending on the version of windows.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply