Post reply

Query to delete all backup files older than a specific date.

  • July 29, 2015 at 1:22 pm

    #300897

    Hell Experts,

    I want to delete all backup files from a folder older than a specific date. But if I use the beklow query, I need to pass how many days of older backup files I need to delete whereas in my case, I dont know how many days/month/syears of old backup files are there in the backup folder.

    Can you suggest me a solution to this trouble?

    EXEC xp_cmdshell 'FORFILES /p c:\BACKUP /s /m *.sql /d -30 /c "CMD /C del /Q /F @FILE"'

    Thanks.

  • July 29, 2015 at 1:32 pm

    #1815880

    What about "/d -0"?

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • July 29, 2015 at 5:08 pm

    #1815975

    Use of 0 will delete all .bkp files from the path but I need to delte files older than the date I mentioned,.

    Thanks.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply