August 6, 2010 at 4:37 am
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:
August 6, 2010 at 5:42 am
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
August 6, 2010 at 7:50 pm
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