Solved Cannot copy .db file, used by another person or program

June 26, 2012 at 01:06:37
Specs: Windows xp
hello
I need to send a database and log files through a FTP client to a support technician for resetting of passwords. now i need to copy these files and send them, but i get the message that i cannot copy them as they are being used by another person or program. there are no programs running and i cannot find it in the processes tab in task manager. i tried to log in as administrator and still get the same message.

please assist, how do i copy these two files


See More: Cannot copy .db file, used by another person or program

Report •


#1
June 26, 2012 at 06:04:34
Make a copy of the files using the regular windows copy and paste method. Then, send the copies via FTP. I can see why you would have problems sending a file that's in use, but you shouldn't have any problems making a copy.

--
Andrew Leonard
BL Technical Services
IT Support Maryland


Report •

#2
June 27, 2012 at 01:39:40
hi
copy and paste does not work, its what i tried the first time. i tried attaching the files but the file size is zero (0). i am told that this is probably because the database engine was not shut down before copying and attaching.
now this is a big problem for me as i am not a DB admin and have very basic knowledge of databases.

how do i shut down the database engine.


Report •

#3
June 27, 2012 at 05:11:21
✔ Best Answer
Try using isusedby to determine which program is using the file. Once you know that, I can give you guidance on shutting it down.

http://www.softpedia.com/get/System...

--
Andrew Leonard
BL Technical Services
IT Support Maryland


Report •

Related Solutions

#4
June 28, 2012 at 02:07:06
hi Andrew

thanks, pretty cool tool this isusedby.

after dragging and dropping the database file i got: PID 0X056C, Name dbsrv8.exe.



Report •

#5
June 28, 2012 at 12:16:43
Open your services console (by clicking Start, Run, typing services.msc, and pressing enter). Look on the list for something along the lines of SQL Anywhere, or ASA anywhere, or even dbserv8. Only look at the ones that have a "started" status, as they couldn't be using the file if they were stopped. Once you find it, right click it, go to all tasks, and click stop. Once stopped, the file should be freely accessible.

--
Andrew Leonard
BL Technical Services
IT Support Maryland


Report •

#6
June 29, 2012 at 02:42:28
hello
i managed to locate the engine thank you. there was nothing in the services console, the database engine was running in the task bar, all i had to do was restore and shut it down. this is a case of learning new software and how it functions..

thanks a lot, ive attached the database and sent it on its way.

thank you


Report •

#7
June 29, 2012 at 10:36:38
Glad I was able to help, would you mind marking one of my answers as "Best Answer?'

--
Andrew Leonard
BL Technical Services
IT Support Maryland


Report •

#8
October 23, 2012 at 02:04:47
Connect Sql Server and Right Click on the desired database. Go to Tasks and select take offline. Now you can copy the mdf and ldf files. After Copying Select Tasks->Bring online.

Ravikumar
pvs_ravikumar@yahoo.com


Report •


Ask Question