What are the challenges you face when working across database platforms? Take the survey
Options

Concurrent restores from the same backup file

vesredgatevesredgate Posts: 14
edited October 30, 2007 9:28AM in SQL Backup Previous Versions
Hi,

I’m trying to run 2 restores concurrently and getting this error message:

Error: Cannot open file "\\myserver\D$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\mydatabase.sbak". The process cannot access the file because it is being used by another process.

I thought it was supposed to be fixed in 5.2:

Bug fixes and enhancements in 5.2:
.......................................................................................
- Ability to perform concurrent restores from the same file on different servers

Is there a way to fix this?

Thanks,
Vlad

Comments

  • Options
    You can ignore this message. This problem seems to be fixed in 5.2. I just didn't realize that I would need to run "Upgrade server components" after 5.2 installation.

    Thanks.
Sign In or Register to comment.