I have 2 servers running SQL Server 2014 which are in different location. Server 1 does not see Server 2 and vice versa. I have a shared drive where both servers can access. I have created a Backup job to create the backup on the shared drive which is working fine. The issue I'm having is with the database restore.
I'm seeing the following in the SQL log:
Error: 18204, Severity: 16, State: 1.
BackupDiskFile::OpenMedia: Backup device 'Z:\BackUp\SalesDB.bak' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).
Any help and solution is greatly appreciated.