Backup files are not deleted by automatically, but as per backup logs Cleanup task working without any errors.
I have verified that server side,
1. Event viewer - there is no errors
2. Error log - there is no errors
3. Job (SQL Server Agent > Jobs), job running under windows authentication
Executed manually as below command that also working without any errors, why that backup files are not deleted? If anyone facing same issues or how to fix it?
Maintenance Cleanup on Local server connection
Cleanup Database Backup files
Age: Older than 5 Days
Task start: 2014-08-26T00:00:30.
Task end: 2014-08-26T00:00:50.
Command:EXECUTE master.dbo.xp_delete_file 0,N''E:\SQL_DB_Backup\Full_Backup'',N''bak'',N''2014-08-21T00:00:30'',1