I would like to say that i had configured "Automatic DB Backup" as well as "Automatic DB Cleanup Task" through "Maintenance Plan" in MS SQL Server 2012 on my Production Database. And that is working properly. I had set up my "Maintenance Clean up" task "Older than 4 Weeks".
Using the following T-SQL Statement:-
select * from
I am able to view the backup history of my DB. That is working properly through maintenance plan schedule.
I setup Automatic Backup of 3 Databases through the "Maintenance Plan", But I had configured Maintenance Cleanup Task to delete files older than 4 weeks. During the last month there are 90 (Backup) files . I configured this plan on 26-03-2015, so now my Maintenance Cleanup Task is working now and I also delete (backup files, .bak) from the specified location.
Now I am able to check out deleted backup file from specified location with Maintenance Plan. But after few days or few months I may be not able to collect exact deleted backup file records as well as not recognize exact days delete backup file records.
So, I want to know exact deleted (.bak) records from through T-SQL.