I have a strange issue... in addition to our normal backups, there are a bunch of databases on our production SQL server that I backup nightly to an attached drive. We have a separate server that we use for developing reports against, and I use these backups every month or so to copy over the most recent data.
Anyway, the setup is very simple - I have a maintenance plan that first deletes any files in my folder older than one day, then it backs up the databases.
My problem is that occasionally the delete step appears not to work. I don't see any errors in SQL or in the event logs on the server; it just fails to actually delete the previous backups. Unfortunately the drive is only large enough to keep one days worth, so the last few fail.
I am wondering if anyone has any idea why these deletes would be failing and how to resolve this.