Error when restore log file by Backup Online

  • Dear all

    I setup backup online between 2 database by this way

    http://www.sqlservercentral.com/Forums/Topic737294-24-1.aspx

    Recently I usually have this error:

    17207 :

    udopen: Operating system error 32(The process cannot access the file because it is being used by another process.) during the creation/opening of physical device d:\data\xyz_Log.ldf

    17204 :

    FCB::Open failed: Could not open device d:\data\xyz_Log.ldf for virtual device number (VDN) 2.

    And database can not be restored more. If I try it will show "It is in the middle of a restore".

    I've checked, there is no problem with Hard Driver or file or network. There is no other program impacts to this file also. But I don't know why error happens.

    :w00t:

  • At the time of restore some other application (like antivirus) tried accessing this file and it is pending recovery.

    Can you try RESTORE DATABASE databasename WITH RECOVERY?

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • But when I use "WITH RECOVERY", I can't restore next new log file into database any more

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply