I have a SQL instance on which I scheduled daily full and hourly tran backups on my database using Maintenance plan.
For a while every thing went fine, but suddenly it stopped deleting old backups and my disk got fulled.
I didn't see any error in the log file related to this and I can see few errors on backup failed.
but not much information I found on why isn't it deleting the old files.
What might be the reason?
Can someone help me with that?
I can create new MP and test, but want to know and resolve that way.
Thanks in Advance