Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: 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

  2. #2
    Join Date
    Jan 2004
    In a large office with bad lighting
    Some 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 (
    that will let you find the process holding the handle (file) and then kill the process.

    -- This is all just a Figment of my Imagination --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts