How do we move archive files from an old installation to a new one?

SUGGESTED

We had a hard drive crash on our old computer, last year, and moved to new computer. Our backup drive contained the Sage100Con folder and all of the Sage 100 backup and archive files. We got Sage 100 installed on the new system, got our company file installed and working and have been using it for a couple of months. We are using Sage 100 2019 (v. 22.4.27.0).

Our accountants and tax professionals now need to access the company archives that were created in the old installation. I have been asked to put the old company archive files in their proper places so that they appear in SAGE and can be accessed within the program as needed.

I am the IT person here and, though I work with the systems and network, I have no experience using Sage 100. I searched the KnowledgeBase but could find no guidance on this question. Then I tried using support chat to ask this question; the support person sent a sheet of instructions showing how to restore a company file from a backup and then terminated the chat before I could review it or pose any questions. This sheet warns that restoring a company will overwrite the existing company; this does not sound like what we want to do. Is this the proper procedure and, if so, how do we avoid overwriting our current data? (Changing the company name, perhaps?) Or is there another procedure for performing this task?

Previous experience with other software suggested that I might simply place all the zipped archive and backup files in the directories corresponding to those they were in on the old system (C:\Sage100Con and its various subdirectories). I tried making a copy of one archive file and moving it from the backed-up “Company” directory to the corresponding directory on the new system. It does not appear, either in Sage 100 or in Sage Administrator.

How can we can add these archive files to the new installation so that they show up in the Sage 100 Company List's "Show Archives" and the Database Administrator for Sage 100's "Tune up / Back Up / Restore" windows?

Thank you for any advice and for the time and energy you spent reading and considering this question.

  • 0
    SUGGESTED

    Hi Byron. Not sure if you have resolved this or not, but there are 3 scenarios here:

    • If you have a .zip backup of the archives, just restore them in Database Administration on the server
    • If you have no backup, but the archive is old enough that you have a copy in the old MB7 folder (pre-SQL version 19 and lower), then just re-migrate those archives in Database Administration
    • If you have neither of these, but just have the database folder for the archive containing the SQL database (.MDF) and Log file (.LDF), but they are not connected to SQL, we have a service ( for an additional charge) to manually recover those databases, assuming they are not damaged. Contact Support to submit a request and quote for this service.