Home Forums SQL Server 2005 Administering Maintenance Plan not deleting physical backup file RE: Maintenance Plan not deleting physical backup file

  • March 2, 2009 at 5:09 pm

    #952178

    Manually use this query and schedule it..

    declare @dt datetime

    select @dt=getdate() - N-- N is the files with Ndays old

    EXECUTE master.dbo.xp_delete_file 0,N'Backup Location',N'BAK',@dt