I'm trying to restore a copy of a database that has a filestream and am getting the error below.
I've tried with move option to specify a new path and left it with default path, neither worked. Did a trace with procmon, didn't see anything. FileStream1 is a new folder that the restore process creates. I've deleted the folder, tried it with a new name,
re-took the backup from the source machine, restarted SQL, rebooted the machine, drive permissions are open.
I've run out of ideas on how to debug further. Looking up the error online wasn't much help either.
Msg 3634, Level 16, State 1, Line 1
The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'OpenFile' on 'X:\Data\FileStream1\4ecb2e48-0eee-4c99-a3f0-f1e6c7f00b24\f2efe374-9481-4c1b-a7f2-dcdcee350807\0000001b-0000aaa6-00f6'.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
SQL Server 2008 SP 1, MS Server 2008 R2 Server
View Complete Post