the file is open in sql server

[johnmc]

i just tried to copy some files and got an error that contacts.ADF and contacts.ALF couldn't copy bec 'the file is open in sql server'.  wondering what i may be missing.  john

[GLComputing]

Those are the ACT! database files and the SQL engine opens them as soon as Windows starts.

Why are you trying to copy them?

[johnmc]

thx.  i didn't realize sql ran on boot.  thought it was on opening act.  

it's always nice to copy files, you know?  i've got my BU's but didn't realize the files got locked up on boot sys tray stuff.

[GLComputing]

The best way is to use the ACT! backup. This creates a ZIP file that you can copy

[johnmc]

roger that.

[GregH]

The ACT backup will also include all of your templates, documents, etc. so you get the full package.