Reg: Automatic Delete the three days older backup file

• vs.satheesh

  SSCrazy

  Points: 2392

  More actions

  August 13, 2012 at 3:10 am

  #280077

  Hi All

  My requirement three days old backup file should be delete automatically.Crrently my backup plan not working properly.baechuse of this i am using folloeing Query .In this Query i called throug JOB.

  DECLARE @DateString CHAR(10)

  SET @DateString = CONVERT(VARCHAR(10),GETDATE()-3,121)

  EXECUTE master.dbo.xp_delete_file 0,N'\\192.168.0.242\Backups\ScheduleDBBkup\218 Server\UMS\',' ',@DateString

  In this above Query last two weeks executed good.but now a day its deleted same day.what is a problem.please replay me.

• SQL Surfer '66

  SSCertifiable

  Points: 5161

  More actions

  August 13, 2012 at 5:31 am

  #1525004

  There's no file extension specified as the second parameter. I think that's your problem.