Hi Guys !
I have Log shipping running Windows 2000 and SQL SERVER 2000 . Implemented using Log shipping Maintenance Plan. Primary and Monitor server are on the same Box.
Most of time the Works fine but some time I am geeting these errors
1. Some time copy job on standby server Fails the Error message is " The process cannot access the file because it is being used by another process."
What parameter what I have to change to avoid this errors
2. Transaction Restore Fails whenever some one Loged in Standby Server during restore. I tried checking terminate users option.
When I ran profiler I did not see alter statement to kill the existing user
Your help is greatly appreciated