Cannot copy a SQL Express file from a non-bootable machine
I have a user with a POS system that runs on MS SQL Express. I believe it is V2008. Their machine died and is unbootable but the system hard drive is readable. I am trying to copy the *.dat file their app uses to another machine to get them up again (no they didn't have a backup) but when I try to copy the file it tells me the file is in use. I have tried to take ownership of the file which appears to be successful but I still get the error.
I tried to use NovaStor backup to backup the file but it says it is in use. The hard drive is connected via a USB drive so the SQL program is not running or accessing the file. I assume it is an issue with the file type and SQL Express.
Is there a way to extract this file from the old hard drive and move it to a working machine so I can get their business up and running again?
Thanks so much in advance for your help.
Try to stop Windows Search service and try copy file again.
If this will not work from Explorer, try use CMD as Administrator and copy over file manually.