October 31, 2016 at 10:12 am
We recently updated our production server to include a secondary file which has static archive data in it. The copy uses Flash Copy to move the production information to Test. Once this was done we are now getting FCB::Open failed: Could not open file F:\Archive\Archive.ndf for file number 4. OS error:32(the process cannot access the file because it is being used by another process).
When was looking into it, it seemed a lot of issues were due to permissions issues but when I checked the permissions are fine. We had the file originally created on the Test server before doing the same thing on Production.
Since this is a VM I could rebuild it from the production VM as well but any ideas before I go that route?
October 31, 2016 at 12:05 pm
Here are the items I have attempted to get it back and running.
Changed the SQLServer service to LocalSystem
Rebooted the server, still recieved the same error.
Tried to Detach the database to then re-attach but get the same error when I detach the file.
I have even had the Flash copy re-processed a couple of times to see if it was something wrong with the initial one
Unfortunately it continues to give the same error.
When I look at sys.master_files there is only the single database using that file.
October 31, 2016 at 12:33 pm
After doing more digging it looks like the File ID on production is different from the FileID on Test for that particular file.
Since the flashcopy process only does the User databases I will try doing a backup and restore of the system databases to see if that helps.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply