Home Forums SQL Server 2012 SQL 2012 - General FOR FILES command to delete old backup files on remote server RE: FOR FILES command to delete old backup files on remote server

  • February 24, 2015 at 3:19 pm

    #1779768

    Ed Wagner (2/24/2015)

    Is using the master.dbo.xp_delete_file stored procedure an option for you?

    Edit: It's in 2012, right? I'm still on 2008. :crazy:

    Thanks for reply.

    But no, it won't work.

    Careful. xp_delete_file name is deceiving. It only works for native SQL backup files, I use RedGate. It is a holdover from SQL 2000. It was created like that by design to minimize the risk of hackers deleting your entire drive.