Log shipping error

I m getting following error in copy/restore operation
"The process cannot access the file because it is being used by another
process."
This come against the file first_file_000000000000.trn every time copy
restore is done. Only first time it went successful. Error number is 32.
Please tell me how to avoid thisVSS
You could be getting this messaqge because it is trying to restore the log
before the copy is finished. How often do you backup and copy the transactio
n
log?
There is a setting for load delay. The default is 0, you could try setting
that to wait longer for the copy to finish.
Hope this helps
John
"VSS" wrote:

> I m getting following error in copy/restore operation
> "The process cannot access the file because it is being used by another
> process."
> This come against the file first_file_000000000000.trn every time copy
> restore is done. Only first time it went successful. Error number is 32.
> Please tell me how to avoid this
>
>|||VSS wrote:
> I m getting following error in copy/restore operation
> "The process cannot access the file because it is being used by another
> process."
> This come against the file first_file_000000000000.trn every time copy
> restore is done. Only first time it went successful. Error number is 32.
> Please tell me how to avoid this
>
Isn't it obvious what you need to do? The error message tells you that
some other process is using the file that you're trying to copy/restore.
Not a SQL Server problem. You need to figure out what is using that
file. Take a look at http://www.sysinternals.com for some utilities
that will help you figure that out.
Tracy McKibben
MCDBA
http://www.realsqlguy.com