Do you have something that backs up the disk on that day?
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
the backup runs on all days and especially on FRIDAY evening as ususal it runs but found there is sharing of this backup file to either from source or to Destination is working.
I tried during that time to DELETE manually when I got the above message of voilation as the file is in use for sharing, which I have checked but couldn't find which process is attached or which job is engaged, since there is no evidence that this sharing should work.
Absouletely clue less, sorrow any missing factor which I couldn't see in broader way.
Not sure what you are saying - is the backup running when yoou try to access the file or not?
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
Sounds like the tape backup process may be backing it up to tape at the time when the delete is tried. That's what happens on our systems, so we moved the start time of the tape backup process so it was done before the delete.
It is like well after the Full Backup the Old Backup should gets deleted through CLEANUP TASK. This happens all the days but not on FRIDAY Evening. I have monitoried on this evening and found that Old Backup (which is well after the fresh backup, just then) was about to delete as it should be like other times through CLEAN UP TASK. but it wont for couple of hours...
In the meanwhile while monitoring I tried MANUALLY to delete this old backup, then it says 'The Source or Destination File may be in Use'.
When there is no such File Sharing happening on all other days then what kind of sharing happening on this PARTICULAR FRIDAY?
Where are the places and points I should investigate, your suggestion is much aprreciated.
What is your disk backup schedule for each day. What is your delete schedule for each day.
Still not clear whether you are saying it is the disk backup that is causing the problem.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
I've seen many posts here that the cleanup task of a maintenance plan doesn't work. I believe the solution has been to redo the maintenance plan. I just use custom scripts, so I avoid that issue.
The Full backup scheduled everyday at 10 PM completes in 50 - 55 Minutes and thereafter goes with Cleanup task with the old backup, so It keeps only the latest backup.
This is the procedure every weekday but not on Friday as something forcing not to delete 'this old backup'.
Definetely, it is not the disk backup to tape because if this backup is scheduled to tape then should happen on all days but something which is still unknown force is sharing this file oN FRIDAY. (sharing file is working hard on weekend night )
Maintanance Task Failure
Posted - 06/08/2012 : 10:34:58
