Backing up Sage line 50

Posted on 2009-05-02
Last Modified: 2012-05-06
I have users remoting into our terminal servers using Sage line 50 accounts plus. I am planning to do an offsite backup via FTP, but I want to know what files/folders I need to backup..can anyone help me out?
Question by:Dan560
    LVL 13

    Accepted Solution

    For just the data files - then the ACCDATA folder under your company (default C:\Program Files\Sage\Accounts\ACCDATA ) holds all the company data.
    For Layouts, Reports etc you will need to look to these folders too.

    If you have a multi company, then the data files can be found in the ACCDATA folder under that company (COMPANY.001 etc).


    LVL 31

    Assisted Solution

    Everything in the ACCDATA folder and subdirectories thereof.  If this is a multi-company version then the COMPANY file says whereabouts to look for the ACCDATA directories.
    LVL 31

    Expert Comment

    must learn to type faster...
    LVL 2

    Author Comment

    Thanks for your advice!
    LVL 10

    Expert Comment

    by:Bruce Denney
    WARNING:  With Sage 50 simply backing up the files is not enough.

    The data can get corrupted, within the application there is a "Data Check" routing, the user is prompted to run this when they do a backup.  This checks the integrity of the databases.  Unless you have a clean set of data the backup could be virtually useless.  The problem is that whilst one or two errors might be fixable, you can get to the situation where you have several errors which are in part of the data that is not that noticeable, part of the audit trail from 6 months ago and by the time the error is detected the backup have been overwritten or a lot of data has been entered.

    If you still want to attempt to just backup the files and not worry about the integrity of the data, then I would also warn you about users left logged in and the locking of files so they can't be updated.

    FTP is rather bandwidth intensive, there is a utility called rsync which has been ported to Windows from *nix and is excellent, it only sends the changes within files so uses a fraction of the bandwidth.

    I  get the users to create a backup file and store it in a folder that is covered by the main backup covering the entire organisation.  

    Worth noting that Sage are rumoured to be switching to MySQL for the database at the next release, so it will be all change for backups not using the built in backup routine.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    As the Marketing Director for the company I work for, time is a commodity that I have relatively little of.  My time is divided between coaching my team, creating a direction for our company's future AND actually getting stuff done.  As a result, I …
    Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now