When trying to copy your Sage ACT! database files manually, you receive the following message:
"The action can’t be completed because the file is open in SQL Server (ACT7) Close file and try again."
Product Family: Sage ACT!
Product: Sage ACT! Pro, Sage ACT! Premium
The Sage ACT! database files are locked by Microsoft SQL Server.
- Review the following article for instructions on moving a Sage ACT! database:
Title: How to Move an ACT! by Sage Database Without Doing a Backup and Restore
Answer ID: How to create a manual backup or copy and move an Act! database without doing a backup and restore
- Copy database files to new location
- Open database to test