Scheduled transaction log backup Failed

Hi Greeting,

Sql sever7
OS winNT

We have scheduled transaction log backup for user database to run every one hour. Now the transaction has failed. it gives out put

[12] Database oas: Delete Old Backup Files...
Unable to delete file E:\mssql7\tlogs\oas\oas_tlog_200608111300.TRN. 0 file(s) deleted.

When we try to delete the file manully, we get alert message "can not delelte the file as it is in use."

Please suggest how to solve this.

Awating for reply

Thanks in Advance
AdilSome other process is holding on to the file and won't let go. NetBackup is notorious for that sort of thing, as are other applications. You can:

1. Reboot the server
2. Kill the process holding on to the file.

There is a nice little windows utility called ProcessExplorer (http://www.sysinternals.com/Utilities/ProcessExplorer.html)
that will let you find the process holding the handle (file) and then kill the process.sql