Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    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
    Adil

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    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 (http://www.sysinternals.com/Utilitie...sExplorer.html)
    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
  •