I have SQL 2012 Database setup in Full Recovery mode.
I have Maintenance task setup with backing up every day 1 Full Backup & hourly backup of transaction logs.
In the plan I have setup to remove the data older than 1 day, however the data is still sitting on disk taking lot of space.
Now, here is what I want to achieve:
The full backup to be done at midnight & transaction log backup every hour, once the next full backup kicks in & is successfully accomplished, the older full backup & logs should be deleted from the disk.