" Cannot copy ***data file: It is being used by another person or program, close any programs that might be using the file and try again"
I have stopped MS SQL, stopped IIS etc - ANY SUGGESTIONS?
VinceDetach the database before trying to copy it.|||
Quote:
Originally Posted by seniorinsight
Hello - I am trying to copy a database file from our existing server into an FTP site so I can download and then upload to a new server. When using the file explorer and copy command I recieve an error that the states
" Cannot copy ***data file: It is being used by another person or program, close any programs that might be using the file and try again"
I have stopped MS SQL, stopped IIS etc - ANY SUGGESTIONS?
Vince
Use the Backup tool from Enterprise manager. Copy and load the backup on your new server. This is the proper way to transfer databases.
No comments:
Post a Comment