January 3, 2011 at 5:24 am
Sometimes during database backups, old backup files cannot be deleted because they are locked by another application. I'm pretty sure this other application is the Windows operating system. Right now, the only way I know of the unlock a file that is locked by the operating system is to reboot the server. Is there any other way to unlock a file that is locked by the operating system? Thanks.
:crazy:
January 3, 2011 at 5:32 am
If that occurs with our backup jobs, it's always an xcopy still trying to copy the file to a safe zone.
We examine why that copy is taking that long and relaunch the backup job.
In extreme cases, we kill the xcopy app. using task manager.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 3, 2011 at 5:37 am
Grab a copy of sysinternals process manager, that can show exactly what app really is holding the file open.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 3, 2011 at 9:17 am
sysinternals: http://technet.microsoft.com/en-us/sysinternals/bb896653
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply