Need to know where email file extensions and location for XP clients

[sam9000]

We are running ACT 2010 Premium on a simple peer to peer network.  Our ACT database files are located on a server (Windows 2003), and we are using the ACT internet mail client (Outlook is not an option for us).  I have been told that each user's email files are kept resident on their PC rather than on the server with the ACT database.  I have also been told that these email files can be readily backed up by copying them with any copy utility.

Is this information correct?  If so, where does ACT store the email database and what are the names of the files that need to be backed up to preserve a user's email correspondence history? Clients are Windows XP Pro

Thanks for your help, and have a great day!

[GLComputing]

They are stored in a SQL database... you can't copy them without stopping the SQL service

See this ACT! Knowledge base article -
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1921...

[sam9000]

I found them:

c:/documents and settings/all users/shared documents/ACT/ACT for windows/email/12/ActEmailMessageStore.mdf

[GLComputing]

Remember - DO NOT copy them without stopping the SQL service. Do so will usually damage them or, at least, the backup may not be usuable

[sam9000]

Thanks. Can you tell me the exact name or typical name of the sql service.

[GLComputing]

MSSQL$ACT7

Have a look at
http://blog.glcomputing.com.au/2009/09/automating-backups-for-act-by-sage.html